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.