1.1.1

Syntax
AUTOCOMMIT { ON | OFF }
Description
Turns the connection's auto-commit mode on or off. JDBC specifies that the default auto-commit mode is ON.
Certain types of processing require that auto-commit mode be OFF.
If auto-commit mode is changed from off to on when a transaction is outstanding, that work is committed when
the current transaction commits, not at the time auto-commit is turned on. Use commit on page 439 or rollback
on page 455 before turning on auto-commit when there is a transaction outstanding, so that all prior work is
completed before the return to auto-commit mode.
Example
sqlf(PEERCLIENT)> AUTOCOMMIT off;
sqlf(PEERCLIENT)> insert into airlines VALUES ('NA', 'New
Airline', 0.20, 0.07, 0.6, 1.7, 20, 10, 5);
1 row inserted/updated/deleted
sqlf(PEERCLIENT)> commit;
before first
Moves the cursor before the first row, then fetches the row.
Syntax
BEFORE FIRST
int Identifier
Description
Moves the cursor before the first row, then fetches the row. If there is no current row, it returns the message No
current row.
The cursor must have been created with the get scroll insensitive cursor on page 446 command.
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)> before first scrollCursor;
No current row
close
Closes the named cursor.
vFabric SQLFire User's Guide438
vFabric SQLFire Reference