RE: SETLL in SQL ?

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Michael_Schutte@xxxxxxxxxxxx
>
> What do you mean?  the program I pulled it from has been in use since
> 1998.
> Page Up/Page Down works properly even after end of cursor is reached.
>
> The fetch relative is only executed when the page up is pressed... on a
> page down, a regular fetch is executed without positioning.

If you initially created the cursor with a "position to" (in SQL terms, a
WHERE clause such as WHERE NAME >= "G"), and then immediately try to roll
back (to get the last page of names starting with "F") you cannot use the
RELATIVE technique.

If your cursor contains ALL the records in the file, then you can certainly
roll through them, but typically the user wants to position to a starting
key value, which requires the WHERE clause above (which corresponds to a
SETLL in RPG).  Once you've done that, there's no way to use that cursor to
get previous records.

Joe