Each async_statement_identifier assignment is case-sensitive and must be unique across all active connections.
The maximum length of each async_statement_identifier is 30 bytes.
The value for :async_statement_identifier_variable_name must be a fixed or varying length character variable no longer than 30 bytes.
If there is no outstanding asynchronous SQL statement, then the exception condition "no outstanding asynchronous SQL statement" is raised.
- SQLCODE is set to -650.
- SQLSTATE is set to '04000'.
If the specified asynchronous SQL statement has not completed, then the exception condition "SQL statement not yet complete" is raised.
- SQLCODE is set to -651.
- SQLSTATE is set to '03000'.
If the specified asynchronous SQL statement has completed, then the following things happen:
- The runtime finishes processing the request and returns the completion status using the SQLCODE or the SQLSTATE.
- The SQL statement named by async_statement_identifier can no longer be referenced.
TEST is not permitted within the following request types:
- Cursor requests specified by the DECLARE CURSOR statement.
- Dynamic requests specified by the PREPARE or EXECUTE IMMEDIATE statements.