Changes to SQLSetStmtAttr() attributes

For SQLSetStmtAttr() attributes, the ODBC driver supports both ODBC 2.0 and ODBC 3.0 values.

The following table lists the SQLSetStmtAttr() attribute values renamed in ODBC 3.0. The ODBC 3.0 attributes support all of the existing ODBC 2.0 attributes.

Table 1. SQLSetStmtAttr() attribute value mapping
ODBC 2.0 attribute ODBC 3.0 attribute
SQL_BIND_TYPE SQL_ATTR_BIND_TYPE or SQL_ATTR_ROW_BIND_TYPE
SQL_CLOSE_BEHAVIOR SQL_ATTR_CLOSE_BEHAVIOR
SQL_CONCURRENCY SQL_ATTR_CONCURRENCY
SQL_CURSOR_HOLD SQL_ATTR_CURSOR_HOLD
SQL_CURSOR_TYPE SQL_ATTR_CURSOR_TYPE
SQL_MAX_LENGTH SQL_ATTR_MAX_LENGTH
SQL_MAX_ROWS SQL_ATTR_MAX_ROWS
SQL_NODESCRIBE SQL_ATTR_NODESCRIBE
SQL_NOSCAN SQL_ATTR_NOSCAN
SQL_RETRIEVE_DATA SQL_ATTR_RETRIEVE_DATA
SQL_ROWSET_SIZE SQL_ATTR_ROWSET_SIZE or SQL_ATTR_ROW_ARRAY_SIZE
SQL_STMTTXN_ISOLATION or SQL_TXN_ISOLATION SQL_ATTR_STMTTXN_ISOLATION or SQL_ATTR_TXN_ISOLATION