Hi Jay,
AFAIK a cursor has to be declared in the same „compilation unit“ where it
is used (opened/fetched).
Maybe a UDTF is a solution? You can write the whole logic in RPG and
dynamic SQL - and you can declare a cursor on the UDTF where you like.
HTH
Daniel
P.S.: I think you already know this, but here is a link to Scott’s
presentation about UDTFs
[1]Vorschau.png
[2]RPG User Defined Functions &
Table Functions
PDF-Dokument · 768 KB
Am 21.06.2023 um 21:16 schrieb Jay Vaughn <jeffersonvaughn@xxxxxxxxx>:
Well yeah, that is true... just wanted my sql code within my SQLRPGLE
source (for some OCD reason)...
hmm ok, will go with that unless anyone knows a way.
thanks!
Jay
On Wed, Jun 21, 2023 at 3:02 PM McNierney_Chris via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:
You can create a SQL Stored Procedure that returns one or more cursors
that can be consumed by an SQLRPGLE program.
Chris
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Jay
Vaughn <jeffersonvaughn@xxxxxxxxx>
Date: Wednesday, June 21, 2023 at 2:47 PM
To: RPG programming on the IBM i (AS/400 and iSeries) <
rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: sqlrpgle - cursor declared in exportable proc
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<
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<
https://archive.midrange.com/rpg400-l>.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related
questions.
--
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.
--
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.
References
Visible links
1.
https://www.scottklement.com/presentations/RPG%20User%20Defined%20Functions%20%26%20Table%20Functions.pdf
2.
https://www.scottklement.com/presentations/RPG%20User%20Defined%20Functions%20%26%20Table%20Functions.pdf
midrange.com
