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

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