SQLGetStatementOption (Extension Level 1)

The following table lists the options you can specify for the SQLGetStatementOption function.

ValueMeaning
SQL_ASYNC_ENABLESQL_ASYNC_ENABLE_ON

Call any SQL functions on this statement asynchronously.

SQL_ASYNC_ENABLE_OFF

Call any SQL functions on this statement synchronously. This is the default.

SQL_BIND_TYPEAdapter does not support SQLExtendedFetch, so calling the function with this option returns an error (SQL_ERROR).
SQL_CONCURRENCYAdapter does not support cursors, so calling the function with this option returns an error (SQL_ERROR). The client can then invoke SQLError to determine the cause.
SQL_CURSOR_TYPEAdapter does not support cursors, so calling the function with this option returns an error (SQL_ERROR). The client can then invoke SQLError to determine the cause.
SQL_KEYSET_SIZEAdapter does not support cursors, so calling the function with this option returns an error (SQL_ERROR). The client can then invoke SQLError to determine the cause.
SQL_MAX_LENGTH0

No limit. This is intended for use in two-tier adapters so that the client can limit the maximum size of data returned from a binary or character column, to reduce network traffic. It is supported only if the data source supports it. The adapter does not support this option.

SQL_MAX_ROWS0

This is similar to SQL_MAX_LENGTH because it is used in two-tier systems to reduce network traffic. In this case, however, the client is limiting the number of rows. The adapter does not support this option.

SQL_NOSCANQL_NOSCAN_OFF

Adapter scans statements for escape clauses.

SQL_QUERY_TIMEOUTNumber of seconds to wait for a query to execute without returning to the caller.
SQL_RETRIEVE_DATAAdapter does not support cursors, so calling the function with this option returns an error (SQL_ERROR). The client can then invoke SQLError to determine the cause.
SQL_ROWSET_SIZEAdapter does not support cursors, so calling the function with this option returns an error (SQL_ERROR). The client can then invoke SQLError to determine the cause.
SQL_SIMULATE_CURSORAdapter does not support cursors, so calling the function with this option returns an error (SQL_ERROR). The client can then invoke SQLError to determine the cause.
SQL_USE_BOOKMARKSAdapter does not support cursors, so calling the function with this option returns an error (SQL_ERROR). The client can then invoke SQLError to determine the cause.

 

Note  For more information about support or requirements for installation on a specific operating system, see Operating System Availability of WMI Components.

 

 

Show: