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.
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 |