ODBC applications use cursors to manipulate and update result sets. SAP Sybase IQ provides extensive support for different kinds of cursors and cursor operations.
ODBC transaction isolation levels
You can use SQLSetConnectAttr to set the transaction isolation level for a connection. The characteristics that determine the transaction isolation level that SAP Sybase IQ provides include the following:
ODBC cursor characteristics
ODBC functions that execute statements and manipulate result sets, use cursors to perform their tasks. Applications open a cursor implicitly whenever they execute a SQLExecute or SQLExecDirect function.
Data retrieval
To retrieve rows from a database, you execute a SELECT statement using SQLExecute or SQLExecDirect. This opens a cursor on the statement.
Bookmarks
ODBC provides bookmarks, which are values used to identify rows in a cursor. SAP Sybase IQ supports bookmarks for value-sensitive and insensitive cursors. For example, the ODBC cursor types SQL_CURSOR_STATIC and SQL_CURSOR_KEYSET_DRIVEN support bookmarks while cursor types SQL_CURSOR_DYNAMIC and SQL_CURSOR_FORWARD_ONLY do not.