Cursor types

This section describes mappings between SAP Sybase IQ cursors and the options available to you from the programming interfaces supported by SAP Sybase IQ.

• Availability of cursors
  Not all interfaces provide support for all types of cursors.
• Cursor properties
  You request a cursor type, either explicitly or implicitly, from the programming interface. Different interface libraries offer different choices of cursor types. For example, JDBC and ODBC specify different cursor types.
• Bookmarks and cursors
  ODBC provides bookmarks, or 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.
• Block cursors
  ODBC provides a cursor type called a block cursor. When you use a BLOCK cursor, you can use SQLFetchScroll or SQLExtendedFetch to fetch a block of rows, rather than a single row. Block cursors behave identically to embedded SQL ARRAY fetches.