Statement Options
Important
This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use the ODBC driver provided by Oracle.
These options allow customization of a specific execution statement within an application.
| Statement option | Notes |
|---|---|
| SQL_BIND_TYPE | Cannot exceed 2,147,483,647 bytes or available memory. |
| SQL_CONCURRENCY | For allowed values, see the Cursor Type and Concurrency Combinations. |
| SQL_CURSOR_TYPE | The driver does not allow SQL_CURSOR_DYNAMIC. See SQLSetScrollOptions for more information. For allowed values, see the Cursor Type and Concurrency Combinations. |
| SQL_GET_BOOKMARK | Returns a 32-bit integer value that is the bookmark for the current record number. Get only; cannot Set. |
| SQL_KEYSET_SIZE | Can be set only to 0. |
| SQL_MAX_ROWS | The maximum number of rows to return from a result set. |
| SQL_ROW_NUMBER | Returns a 32-bit integer specifying the position of the current row within the result set. Get only; cannot Set. |
| SQL_ROWSET_SIZE | Cannot exceed 4,294,967,296 rows; however, you must have enough virtual memory in your computer to handle your request. |
| SQL_USE_BOOKMARKS | Supports setting SQL_USE_BOOKMARKS to SQL_UB_ON and exposes fixed-length bookmarks. |