ODBCLINK/SE Reference Manual (36217-90410)

ODBCLink/SE Reference Manual Application Development
ODBCLink/SE
©M.B. Foster Associates Limited 1995-2000 33
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 multi-user environment can be affected by operations performed by another user.
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.