Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ ODBC Driver GuideThe HCL OneDB™ ODBC Driver Programmer's Manual serves as a user guide and reference for HCL OneDB™ ODBC Driver, which is the HCL OneDB™ implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
Overview of HCL OneDB™ ODBC DriverThese topics introduce the HCL OneDB™ ODBC Driver and describe its advantages and architecture. The topics also describe conformance, isolation and lock levels, libraries, and environment variables.
Partially supported and unsupported ODBC featuresHCL OneDB™ ODBC Driver supports partial implementation of several ODBC features.
ODBC bookmarksA bookmark is a value that identifies a row of data.

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.