First command

The First command moves the cursor to the first row in the ResultSet, 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

FIRST Identifier

Example

ij> get scroll insensitive cursor scrollCursor as
'SELECT * FROM menu FOR UPDATE OF price';
ij> first scrollcursor;
COURSE    |ITEM                |PRICE
-----------------------------------------------
entree    |lamb chop           |14

Parent topic: ij commands and errors reference

Related concepts

ij commands

ij errors