Re: SQLRPGLE - scrollable cursor, set at a specific record

To put closure on the thread, here is what I found:

exec sql declare C1 DYNAMIC SCROLL cursor for
select * from TLEH order by HID;
exec sql open C1;
exec sql fetch relative :wCount from C1 into :wRecordDS;

where wCount is the RRN number for the record desired. That positioned to the detail record I wanted and still allows me to rollup/rolldown for the next & prior detail record.

On 8/9/2016 9:26 AM, Darren Strong wrote:

... Its not ideal, but you can write the SQL statement to say where HID >=:pID.
You have to close and reopen the cursor for a change in :pID to take
affect, but the real issue is that you can't read backward to values
previous to that key on that open cursor....