×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
midrange.com
