ODBC bookmarks

A bookmark is a value that identifies a row of data.

HCL OneDB™ ODBC Driver supports bookmarks with SQLFetchScroll and SQLExtendedFetch and does not support them with SQLBulkOperations.HCL OneDB ODBC Driver supports bookmarks to the following extent:
  • Uses only variable length bookmarks.
  • SQL_DESC_OCTET_LENGTH is set to 4 for bookmark columns.
  • A bookmark is an integer that contains the row number within the row set, starting with 1.
  • Bookmarks persist only if the cursor remains open.
  • SQLFetchScroll, using SQL_FETCH_BOOKMARK for the fetch orientation argument, is fully supported.
  • SQLBulkOperations does not update the bookmark column for SQL_ADD.

For more information about ODBC bookmarks, see the HCL OneDB ODBC Driver Programmer's Manual.