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. An identifier
that does not specify a connectionName must not be the same as any other
identifier for an async statement on the current connection; an identifier that
specifies a connectionName must not be the same as any other identifier
for an async statement on the designated 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 or designated connection to issue the
SQL statement. The separate thread is closed once the statement completes.