Relative commandThe Relative command moves the cursor to the row
that is the specified number of rows relative to the current row, then fetches
the row.Relative commandCursorsfetching next row
The command displays a banner and the values of the row. The cursor must have
been created with the Get Scroll
Insensitive Cursor command.
SyntaxRELATIVE int IdentifierExampleij> -- autocommit needs to be off so that the positioned update
ij> -- can see the cursor it operates against.
ij> autocommit off;
ij> get scroll insensitive cursor scrollCursor as
'SELECT * FROM menu FOR UPDATE OF price';
ij> last scrollcursor;
COURSE |ITEM |PRICE
-----------------------------------------------
dessert |creme brulee |6
ij> previous scrollcursor;
COURSE |ITEM |PRICE
-----------------------------------------------
entree |lamb chop |14
ij> relative 1 scrollcursor;
COURSE |ITEM |PRICE
-----------------------------------------------
dessert |creme brulee |6