AsyncEnable CLI/ODBC configuration keyword

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