1.0

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 on page 408 command. It displays a banner and the values of the row.
Example
sqlf(PEERCLIENT)> get scroll insensitive with nohold cursor
scrollCursor as
'select * from firsttable order by id';
sqlf(PEERCLIENT)> absolute 3 scrollCursor;
ID |NAME
------------------------
30 |THIRTY
sqlf(PEERCLIENT)> first scrollCursor;
ID |NAME
------------------------
10 |TEN
get scroll insensitive cursor
Creates a scrollable insensitive cursor with the name of the Identifier.
Syntax
GET SCROLL INSENSITIVE [WITH {HOLD|NOHOLD}]
CURSOR
Identifier
AS
String
WITH HOLD is the default attribute of the cursor. For a non-holdable cursor, use the WITH NOHOLD option.
Description
Creates a scrollable insensitive cursor with the name of the Identifier. The command issues a
createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY) call and then
executes the statement with a java.sql.StatementExecuteQuery request on the value of the String.
If the String is a statement that does not generate a result set, the behavior of the underlying database determines
whether an empty result set or an error is issued. If an error occurs in executing the statement, no cursor is created.
sqlf sets the cursor name using a java.sql.Statement.setCursorName request. Behavior with respect to duplicate
cursor names is controlled by the underlying database. SQLFire does not allow multiple open cursors with the
same name.
Scroll-insensitive result sets are not capable of scrolling. That means the cursor can move in only one direction.
When the result set is open, any change to the database table will not reflect.
vFabric SQLFire User's Guide408
vFabric SQLFire Reference