Result sets in ODBC applications

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.
• Row updates and deletes through a cursor
  
• 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.