×
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.
Weird timing.
I just created an SQLRPGLE example similar to this use-case this afternoon.
I used a stored procedure, but I think the concept is the same if you use embedded SQL.
-Run Query or stored proc,
-Open Cursor
-Iterate Results
-Close Cursor
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------
message: 3
date: Thu, 18 Jul 2024 17:53:40 -0400
from: Buck Calabro <kc2hiz@xxxxxxxxx>
subject: Re: Result sets in SQLRPGLE
On 7/18/2024 3:09 PM, stefan@xxxxxxxxxx wrote:
Just started playing with result sets in rpg.
I declare a ds dbt dim(10 000);
Then I declare, prepare ,open and fetch from a cursor.
When reaching eof I do:
exec sql
set result sets array :dbt
for :rowsreturned rows
;
How to deal with a situation when I get more than 10 000 rows? Previous fetch is then overlaid with new data ....
Hi Stefan,
Using a DS is one way to return a smallish result set.
Another way is to open a cursor and leave it open:
exec sql declare myCursor cursor for...
exec sql open myCursor;
exec sql set result sets cursor myCursor;
*inlr = *on;
...the CREATE PROCEDURE shouldn't need to change:
CREATE PROCEDURE myProcedure (
IN...)
DYNAMIC RESULT SETS 1
LANGUAGE RPGLE...
https://www.ibm.com/docs/en/i/7.4?topic=statements-set-result-sets
--
--buck
http://wiki.midrange.com
Your updates make it better!
midrange.com
