Before First

Syntax

BEFORE FIRST int Identifier

Description

Moves the cursor to before the first 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^(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> before first scrollcursor;
No current row