Call Level Interface Guide and Reference

Isolation Levels

The following table map IBM RDBMs isolation levels to ODBC transaction isolation levels. The SQLGetInfo() function, indicates which isolation levels are available.

Table 188. Isolation Levels Under ODBC

IBM Isolation Level	ODBC Isolation Level
Cursor Stability	SQL_TXN_READ_COMMITTED
Repeatable Read	SQL_TXN_SERIALIZABLE_READ
Read Stability;	SQL_TXN_REPEATABLE_READ
Uncommitted Read	SQL_TXN_READ_UNCOMMITTED
No Commit	(no equivalent in ODBC)
Note: SQLSetConnectOption() and SQLSetStmtOption will return SQL_ERROR with an SQLSTATE of HY009 if you try to set an unsupported isolation level.