The following syntax examples declare an INSENSITIVE scrollable cursor and fetch rows at random.
To declare an INSENSITIVE scrollable cursor and fetch rows at random:
EXEC SQL DECLARE c1 INSENSITIVE SCROLL CURSOR FOR
select title_id, royalty
from authors
where royalty < 25 END-EXEC.
EXEC SQL OPEN c1 END-EXEC.
To fetch a row when a cursor is declared and open:
EXEC SQL FETCH LAST FROM c1 INTO :title,:roy END-EXEC.
To fetch a previous row:
EXEC SQL FETCH PRIOR FROM c1 INTO :title,:roy END-EXEC.
To fetch row 20:
EXEC SQL FETCH ABSOLUTE 20 FROM c1 INTO :title, :roy
END-EXEC.