next

Fetches the next row from the named cursor created with the get scroll insensitive cursor command.

Syntax

NEXT Identifier

Description

Fetches the next row from the named cursor created with the Get Scroll Insensitive Cursor. It displays a banner and the values of the row.

Example

gfxd(PEERCLIENT)> get scroll insensitive with nohold cursor 
scrollCursor as 'select * from firsttable order by id';
gfxd(PEERCLIENT)> absolute 3 scrollCursor;
ID         |NAME
------------------------
30         |THIRTY
gfxd(PEERCLIENT)> first scrollCursor;
ID         |NAME
------------------------
10         |TEN
gfxd(PEERCLIENT)> next scrollCursor;
ID         |NAME
------------------------
20         |TWENTY