ODBC Programmer Reference › Supported Isolation and Lock Levels

Supported Isolation and Lock Levels

Transaction isolation is set with the SQLSetConnectOption ODBC API function. The default transaction isolation can be set using the ODBC Administrator. The ability to set the default transaction isolation is an IDMS extension. The ODBC driver supports the following two transaction isolation levels:

SQL_READ_COMMITTED

(Default) Corresponds to the SET TRANSACTION CURSOR STABILITY CA IDMS SQL Statement.

SQL_READ_UNCOMMITTED

Corresponds to the SET TRANSACTION TRANSIENT READ CA IDMS SQL Statement.