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.