When an ODBC 3.x application calls SQLGetInfo in an ODBC 2.x driver with the SQL_XXXX_CURSOR_ATTRIBUTES1 information type (for dynamic, forward-only, keyset-driver, or static cursors), the setting of the bits returned by Driver Manager depends upon what the ODBC 2.x driver returns for the corresponding ODBC 2.x information types. The bits are set as follows:
| Bit in SQL_XXXX_ CURSOR_ ATTRIBUTES1 |
Cursor type |
ODBC 2.x information type |
| SQL_CA1_NEXT | All | SQL_FETCH_ DIRECTION |
| SQL_CA1_ ABSOLUTE SQL_CA1_ RELATIVE SQL_CA1_ BOOKMARK |
Dynamic, keyset-driver, static | SQL_FETCH_ DIRECTION |
| SQL_CA1_LOCK_ NO_CHANGE SQL_CA1_LOCK_ UNLOCK SQL_CA1_LOCK_ EXCLUSIVE |
Dynamic, keyset-driver, static | SQL_LOCK_TYPES |
| SQL_CA1_ POSITIONED_ UPDATE SQL_CA1_ POSITIONED_ DELETE SQL_CA1_SELECT_ FOR_UPDATE |
All | SQL_POSITIONED_STATEMENTS |
| SQL_CA1_POS_ POSITION SQL_CA1_POS_ DELETE SQL_CA1_POS_ REFRESH SQL_CA1_POS_ BULK_ADD |
Dynamic, keyset-driver, static | SQL_POS_ OPERATIONS |