Transaction isolation levels
HCL Informix® ODBC Driver supports three transaction isolation levels for the Informix database server.
The following table lists the transaction isolation levels
that HCL Informix
ODBC Driver supports
for the Informix database
server.
| Database servers | Transaction isolation levels |
|---|---|
| HCL Informix |
|
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 IBM® Informix ODBC Driver Programmer's Manual.