Last

Syntax

LAST Identifier

Description

Moves the cursor to the last row in the ResultSet, then fetches the row. The cursor must have been created with the Get Scroll Insensitive Cursor command. It displays a banner and the values of the row.

Note:

This command works only in a Java^(TM) 2 Platform, Standard Edition, v 1.2 (J2SE) or higher environment.

Examples

ij> get scroll insensitive cursor scrollCursor as 
'SELECT * FROM menu FOR UPDATE OF price';
ij> absolute 5 scrollCursor;
COURSE    |ITEM                |PRICE
-----------------------------------------------
entree    |lamb chop           |14
ij> last scrollcursor;
COURSE    |ITEM                |PRICE
-----------------------------------------------
dessert   |creme brulee        |6