[This is preliminary documentation and subject to change.]
| Option | Values |
|---|---|
| SQL_ASYNC_ENABLE | SQL_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_TYPE | The adapter does not support SQLExtendedFetch, so calling the function with this option returns an error. |
| SQL_CONCURRENCY | The adapter 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. SQLError informs the client that the adapter does not support this facility |
| SQL_CURSOR_TYPE | The adapter 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. SQLError informs the client that the adapter does not support this facility |
| SQL_KEYSET_SIZE | The adapter 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. SQLError informs the client that the adapter does not support this facility |
| SQL_MAX_LENGTH | 0 - No limit. This is intended for use in two-tier adapters where the client wants to limit the maximum size of data returned from a binary or character column in order to reduce network traffic. It supported only if the data source supports it. The adapter does not support this option. |
| SQL_MAX_ROWS | 0 - This is similar to SQL_MAX_LENGTH in that 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_NOSCAN | QL_NOSCAN_OFF - The adapter scans statements for escape clauses. |
| SQL_QUERY_TIMEOUT | The number of seconds to wait for a query to execute without returning to the caller. |
| SQL_RETRIEVE_DATA | The adapter 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. SQLError informs the client that the adapter does not support this facility. |
| SQL_ROWSET_SIZE | The adapter 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. SQLError informs the client that the adapter does not support this facility. |
| SQL_SIMULATE_CURSOR | The adapter 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. SQLError informs the client that the adapter does not support this facility. |
| SQL_USE_BOOKMARKS | The adapter 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. SQLError informs the client that the adapter does not support this facility. |