Async

Syntax

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 ijPrepare 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.