Mapping the Cursor Attributes1 Information Types

When an ODBC 3.0 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