RE: SETLL in SQL ?

From: Paul Raulerson

You didn't hear what I asked Joe; I asked about scrollable cursors, which
*do* allow you to
move around by relative position in a cursor. As in this kind of stuff.
Note the fetch statement.

Paul, you are missing the point. A FETCH RELATIVE does not position by key.
You cannot position to the first record with a "G" by using a single FETCH
RELATIVE because you don't know how many records to use in the RELATIVE
clause. The best you can do is jump around the file using an old-fashioned
binary search, and believe me, that won't perform too well on a large file.

Have I made myself clear? If not, there's really nothing else I can say.

Joe

EXEC SQL

FETCH RELATIVE 3 FROM THISEMP

INTO :EMP-NUM, :NAME2,

:JOB-CODE

END-EXEC.