Relative command

The Relative command moves the cursor to the row that is the specified number of rows relative to the current row, then fetches the 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.

Syntax

RELATIVE int Identifier

Example

ij> -- 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