Enables or disables the ability to execute queries asynchronously.
- db2cli.ini keyword syntax:
- AsyncEnable = 0 | 1
- Default setting:
- Queries can be executed asynchronously.
- Usage notes:
- This option allows you to enable or disable support that allows
queries to execute asynchronously. This only benefits applications
that were written to take advantage of this feature by setting the
SQL_ATTR_ASYNC_ENABLE attribute using SQLSetStmtAttr() or SQLSetConnectAttr().
- 0 = Queries are not executed asynchronously
- 1 = Allow queries to be executed asynchronously. The application
must also enable the asynchronous functionality by setting SQL_ATTR_ASYNC_ENABLE
using SQLSetStmtAttr() or SQLSetConnectAttr().
(default)
Once a function has been called asynchronously, only the
original function, SQLAllocHandle(), SQLCancel(), SQLSetStmtAttr(), SQLGetDiagField(), SQLGetDiagRec(),
or SQLGetFunctions() can be called on the statement
handle, until the original function returns a code other than SQL_STILL_EXECUTING.
Any other function called on any other statement handle under the
same connection returns SQL_ERROR with an SQLSTATE of HY010 (Function
sequence error).