Next command

The Next command fetches the next row from the specified named cursor.

The command displays a banner and the values of the row. The cursor must have been created with the Get Cursor or Get Scroll Insensitive Cursor command.

Syntax

NEXT Identifier

Example

ij> get cursor menuCursor as 'SELECT * FROM menu';
ij> next menuCursor;
COURSE    |ITEM                |PRICE          
-----------------------------------------------
entree    |lamb chop           |14
ij>

Parent topic: ij commands and errors reference

Related concepts

ij commands

ij errors