Re: sqlrpgle - cursor declared in exportable proc

Can't say I've tried this...

But I think you should be able to open a cursor in a *SRVPGM procedure and
consume it from somewhere else...

After all, a cursor is a Db level construct.

Take a look at this article..
https://www.itjungle.com/2010/08/25/fhg082510-story02/

You'll probably need to define the *SRVPGM procedure as an external stored
proc and then instead of calling it via RPG's CALLP, you'll use an SQL CALL.

Also not that the *SRVPGM module will need CLSSQLCUR(*ENDACTGRP) instead of
the oft-misused *ENDMOD.

Then do an
Exec SQL
ASSOCIATE RESULT SET LOCATOR :myResults
WITH PROCEDURE myExtProc;

Exec SQL
ALLOCATE localCursor CURSOR
FOR RESULT SET :myResults;

HTH,
Charles




On Wed, Jun 21, 2023 at 12:47 PM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

is it possible to declare an sql in an exportable procedure, and use that
cursor in the consuming executable?

tried it but my consuming RPG pgm will not compile, saying it cannot find
the c1 cursor...
What am I missing or is it just not possible?

tia

Jay
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.