Hello,
I'm using a SQL query in a RPG IV ILE program and the records founded are display on the screen (pressing the rollup button shows the next records). It works good but require too much time because of the thousands of record and the complexity of the query.
So I'd like that the SQL query only fill the result table with x records (the number display on the screen). And rollup will fill the table with the x next records (I think STRSQL tool works in this way).
Thank you for your help.
Philb
I'm using a SQL query in a RPG IV ILE program and the records founded are display on the screen (pressing the rollup button shows the next records). It works good but require too much time because of the thousands of record and the complexity of the query.
So I'd like that the SQL query only fill the result table with x records (the number display on the screen). And rollup will fill the table with the x next records (I think STRSQL tool works in this way).
Thank you for your help.
Philb
Comment