ODBC Descriptor Field Support
The Relational Interface provides ODBC v3.51 descriptor field support except for the options listed in the following table.
Table 4
Exceptions to ODBC Descriptor Support
fOption
Comments
SQL_DESC_BIND_TYPE
For application parameter descriptors (APDs), only SQL_BIND_BY_COLUMN is supported.
SQL_DESC_ROWVER
See Exceptions to ODBC Interface Support.
Descriptor Fields and Bitness Values
Note that some of the descriptor fields that can be set through the various ODBC SQLSet and SQLGet functions have been changed to accommodate 64-bit values while others are still 32-bit values. If you are using the 64-bit ODBC driver, ensure that you use the appropriate sized variable when setting and retrieving these fields. For more information, refer to the Microsoft ODBC documentation.
A point of clarification is that SQL_ROWSET_SIZE is supported by both SQLGetStmtOption and SQLGetStmtAttr. If you are using the 64-bit ODBC driver and you call either SQLGetStmtOption or SQLGetStmtAttr, a 64-bit value is returned in *ValuePtr when that attribute parameter is set to SQL_ROWSET_SIZE.
SQLSetStmtOption Options
The section discusses the PSQL support for the following SQLSetStmtOption options:
•
SQL_BIND_TYPE
•
SQL_CONCURRENCY
•
SQL_CURSOR_TYPE
•
SQL_RETRIEVE_DATA
•
SQL_ROWSET_SIZE
•
SQL_USE_BOOKMARKS
The following tables indicate valid set values for each option.
 
Table 5
Binding, Concurrency, and Cursor Types Support by Access Method
 
ODBC Cursor Library
Current PSQL ODBC Drivers
SQL_BIND_TYPE
SQL_BIND_BY_COLUMN or a length to indicate row-wise binding
SQL_BIND_BY_COLUMN or a length to indicate row-wise binding
SQL_CONCURRENCY
SQL_CONCUR_READ_ONLY or SQL_CONCUR_ VALUES
(for SQL_CONCUR_ROWVER the library substitutes SQL_CONCUR_VALUES, returns SQL_SUCCESS_WITH_INFO and sets SQLSTATE to 01S02)
(for SQL_CONCUR_LOCK the library returns SQL_ERROR returned with SQLSTATE of S1C00)
SQL_CONCUR_READ_ONLY or SQL_CONCUR_ROWVER or SQL_CONCUR_LOCK
(for SQL_CONCUR_VALUES the driver automatically substitutes SQL_CONCUR_ROWVER)
SQL_CURSOR_TYPE
SQL_CURSOR_FORWARD_ONLY or SQL_CURSOR_STATIC
(for SQL_CURSOR_KEYSET_DRIVEN and SQL_CURSOR_DYNAMIC the library substitutes SQL_CURSOR_STATIC, returns SQL_SUCCESS_WITH_INFO and sets SQLSTATE to 01S02)
SQL_CURSOR_FORWARD_ONLY or SQL_CURSOR_STATIC or SQL_CURSOR_DYNAMIC
(for SQL_CURSOR_KEYSET_DRIVEN the driver substitutes SQL_CURSOR_STATIC, returns SQL_SUCCESS_WITH_INFO and sets SQLSTATE to 01S02)
 
Table 6
Rowset Size and Bookmarks Support by Access Method
 
ODBC Cursor Library
Current PSQL ODBC Drivers
SQL_RETRIEVE_DATA
SQL_RD_ON
(for SQL_RD_OFF the library returns SQL_ERROR returned with SQLSTATE of S1C00)
SQL_RD_ON or SQL_RD_OFF
SQL_ROWSET_SIZE
Any value indicating number of rows in the rowset as long as it does not exceed maximum rowset size.
Any value indicating number of rows in the rowset as long as it does not exceed maximum rowset size.
SQL_USE_BOOKMARKS
SQL_UB_ON or SQL_UB_OFF
SQL_UB_ON or SQL_UB_OFF