# Async

#### 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 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 command and is a case-insensitive `ij` identifier; it 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 `ij` Prepare command in this command.

`ij` creates a new thread in the current connection to issue the SQL statement. The separate thread is closed once the statement completes.

#### Example

    ij>async aInsert 'INSERT into menu values (''entree'',''chicken'',11)';
    ij>INSERT INTO menu VALUES ('dessert','ice cream',3);
    1 rows inserted/updated/deleted.
    ij>wait for aInsert;
    1 rows inserted/updated/deleted.
    -- the result of the asynchronous insert

Parent topic: ij commands and errors reference
Related concepts
ij commands
ij errors
Related reference
Absolute
After Last
Autocommit
Before First
Close
Commit
Connect
Describe
Disconnect
Driver
Elapsedtime
Execute
Exit
First
Get Cursor
Get Scroll Insensitive Cursor
Help
Last
LocalizedDisplay
MaximumDisplayWidth
Next
Prepare
Previous
Protocol
Readonly
Relative
Remove
Rollback
Run
Set Connection
Show
Wait For
Comment
Identifier
String