RE: SETLL in SQL ?

If you need to position by key and then move in either direction,

forward or

backward, the only way to do it is using ISAM, unless of course you are
willing to open and close cursors.

What about 2 cursors, one looking forward, one backward? Position to
customer name 'Gre' would be 2 cursors, first:

Select * from customer where customername >= 'Gre'

Second:

Select * from customer where customername < 'Gre' order by customername
desc

Load your first page from cursor1. If you page down, read the next 10
rows from cursor1 (assuming a 10 row subfile). If you page UP on page1
read the first 10 rows from cursor2.

-Walden