The following table map IBM RDBMs isolation levels to ODBC transaction
isolation levels. The SQLGetInfo() function, indicates which
isolation levels are available.
Table 190. 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) | ||
| |||