first

Moves the cursor to the first row in the ResultSet, then fetches the row.

Syntax

FIRST Identifier

Description

Moves the cursor to the first row in the ResultSet, then fetches the row. You first create the cursor with the Get Scroll Insensitive Cursor command. 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