1.1.1

ID |NAME
------------------------
40 |Forty
sqlf(PEERCLIENT)> relative -1 scrollCursor;
ID |NAME
------------------------
30 |THIRTY
sqlf(PEERCLIENT)> after last scrollCursor;
No current row
async
Execute an SQL statement in a separate thread.
Syntax
ASYNC
Identifier String
Description
The ASYNC command lets you execute an SQL statement in a separate thread. It is used in conjunction with
the wait for on page 461 command to get the results.
You supply the SQL statement, which is any valid SQL statement, as a String. The Identifier you must supply
for the async SQL statement is used in the wait for on page 461 command and is a case-insensitive sqlf identifier.
An identifier must not be the same as any other identifier for an async statement on the current connection. You
cannot reference a statement previously prepared and named by the sqlf prepare on page 451 command in this
command.
sqlf creates a new thread in the current or designated connection to issue the SQL statement. The separate
thread is closed once the statement completes.
Examples
sqlf(PEERCLIENT)> async aInsert 'insert into firsttable values
(40,''Forty'')';
sqlf(PEERCLIENT)> insert into firsttable values (50,'Fifty');
1 row inserted/updated/deleted
sqlf(PEERCLIENT)> wait for aInsert;
1 row inserted/updated/deleted
-- the result of the asynchronous insert
autocommit
Turns the connection's auto-commit mode on or off.
437
sqlf Interactive Commands