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

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 08/10/2016 12:41:54
PM:

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.

My understanding of "fetch relative" is that it is relative to
your current position in the cursor. Thus, I do not understand how an RRN
will work in this instance. Can you explain that? Also, what method are
you using to determine "the RRN number for the record desired"?

Sincerely,

Dave Clark