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.
Transaction processingHCL OneDB™ ODBC Driver implementation of transaction isolation levels and transaction modes is slightly different from the Microsoft™ ODBC implementation of these features.
Transaction isolation levelsHCL OneDB™ ODBC Driver supports three transaction isolation levels for the HCL OneDB™ database server.

Transaction isolation levels

HCL OneDB™ ODBC Driver supports three transaction isolation levels for the HCL OneDB database server.

The following table lists the transaction isolation levels that HCL OneDB ODBC Driver supports for the HCL OneDB database server.


Database servers	Transaction isolation levels
HCL OneDB	SQL_TXN_READ_COMMITTED SQL_TXN_READ_UNCOMMITTED SQL_TXN_SERIALIZABLE

The default transaction isolation level is SQL_TXN_READ_COMMITTED. To change the transaction isolation level, call SQLSetConnectOption() with an fOption value of SQL_TXN_ISOLATION.

For more information about transaction isolation levels, see the SQL_DEFAULT_TXN_ISOLATION and SQL_TXN_ISOLATION_OPTION descriptions in the HCL OneDB ODBC Driver Programmer's Manual.