On my System Power / AS400,
i’m using embedded sql in an RPGLE Program to write a Subfile.
On a large selection the initial fetch is to slow.
When i scroll the speed is good.
Even though i only select 19 rows and fetch 1 row at a time.