ISOLATION LEVEL pragma

The ISOLATION LEVEL pragma determines the isolation level for database accesses performed by an SQL or utility statement.

This pragma is only effective in the following SQL statements:

• CALL and in routines (see section "Pragmas in routines")

• cursor description (for dynamic cursors)

• DECLARE CURSOR (for a static cursor)

• DELETE

• INSERT

• MERGE

• SELECT

• UPDATE

---

ISOLATION LEVEL
{
   READ UNCOMMITTED |
   READ NOWAIT |
   READ COMMITTED |
   REPEATABLE READ |
   SERIALIZABLE
}

---

CAUTION! The ISOLATION LEVEL READ NOWAIT can only be set by Pragma but not within the SET TRANSACTION Statement. If you have specified the ISOLATION LEVEL pragma, any database access performed in connection with this statement takes place under CONSISTENCY LEVEL 1, see "SET TRANSACTION - Define transaction attributes".

If you specify a lower isolation level than specified for the transaction, the isolation level defined for the transaction is no longer guaranteed.

The isolation levels are described in the section "SET TRANSACTION - Define transaction attributes".

If you have specified the ISOLATION LEVEL pragma, any database access performed in connection with this statement takes place under this isolation level.