A_ODBC_ISOLATION_LEVEL configuration variable

Use the A_ODBC_ISOLATION_LEVEL configuration variable to set the isolation level. The default ordering of isolation levels is:

You can change the isolation level by setting the configuration variable A_ODBC_ISOLATION_LEVEL to an integer in the configuration file. The settings are:

Isolation level Setting in configuration file
SQL_TXN_READ_UNCOMMITTED 1
SQL_TXN_READ_COMMITTED 2
SQL_TXN_REPEATABLE_READ 3
SQL_TXN_SERIALIZABLE 4

For example, to set the isolation level to SQL_TXN_READ_COMMITTED, add the following entry to the configuration file:

A_ODBC_ISOLATION_LEVEL 2

If the user-set isolation level is not supported by the driver, the default method of selecting a level is used.