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

[Booth Martin <booth@xxxxxxxxxxxx>]

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