Before First Before FirstCursorsfetching next row 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. 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> before first scrollcursor; No current row