Result sets in SQLRPGLE

Hi,



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 ....

I guess I can only run the set result set statement once?

The expectation is to return a few 100 000 rows ( more than fits into a 16Mb ds );



Obviously I’m missing something.....



Thanks in advance for any kick in the right direction.



Stefan



--