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