Set the isolation level (UNIX only)

Set the isolation level in the odbc.ini file by using the ISOLATIONLEVEL and SQL_TXN_LAST_COMMITTED keywords.

To specify the isolation level in the odbc.ini file, use the following keyword and values:
  • ISOLATIONLEVEL = level
  • SQL_TXN_LAST_COMMITTED = last committed
where level is a number from 0 to 5:
  • 0 = Automatically considers the default based on database type
  • 1 = Read Uncommitted
  • 2 = Read Committed (default for non-ANSI databases)
  • 3 = Repeatable Read (default for ANSI databases)
  • 4 = Serializable
  • 5 = Last Committed

If an application calls SQLSetConnectAttr with the SQL_ATTR_TXN_ISOLATION attribute and sets the value before connecting, and later sets ISOLATIONLEVEL or ISOLVL in the connection string, the connection string is the final value to be used.

The SQL_TXN_TRANSACTION isolation level is not supported on UNIX™ platforms.