ODBCLink/SE Reference Manual | Application Development |
Isolation Levels
Isolation levels allow you to control the degree of concurrency by regulating the extent to which operations performed by one user in a
ALLBASE/SQL allows four different isolation levels:
⊗Repeatable Read (RR)
⊗Cursor Stability (CS)
⊗Read Committed (RC)
⊗Read Uncommitted (RU)
ODBCLink/SE uses the isolation level specified in the ODBC setup screen. The application can later change this by calling SQLSetConnectOptions with SQL_TXN_ISOLATION option.
The recommended isolation level is “RU” for Read Uncommitted. This minimizes the number of locks that are held on your database.
Note: Refer to the ALLBASE/SQL Reference Manual for further information.
ODBCLink/SE |
|
©M.B. Foster Associates Limited | 33 |
