Export (0) Print
Expand All
Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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:
© 2014 Microsoft