After Last

Syntax

AFTER LAST Identifier

Description

Moves the cursor to after the last row, then fetches the row. (Since there is no current row, it returns the message: No current row."

The cursor must have been created with the Get Scroll Insensitive Cursor command.
Note: This command works only in a Java 2 Platform, Standard Edition, v 1.2 (J2SE) or higher environment.

Example

ij> get scroll insensitive cursor scrollCursor as
'SELECT * FROM menu FOR UPDATE OF price';
ij> after last scrollcursor;
No current row
Related concepts
ij commands
ij errors
Related reference
Absolute
Async
Autocommit
Before First
Close
Commit
Connect
Disconnect
Driver
Elapsedtime
Execute
Exit
First
Get Cursor
Get Scroll Insensitive Cursor
Help
Last
LocalizedDisplay
MaximumDisplayWidth
Next
Prepare
Previous
Protocol
Readonly
Relative
Remove
Rollback
Run
Set Connection
Show Connections
Wait For
Comment
Identifier
String