SQLJ SET-TRANSACTION-clause
The SET TRANSACTION clause sets the isolation level for the current unit of work.
Syntax
Description
- ISOLATION LEVEL
- Specifies one of the following isolation levels:
- READ COMMITTED
- Specifies that the current isolation level is cursor stability.
- READ UNCOMMITTED
- Specifies that the current isolation level is uncommitted read.
- REPEATABLE READ
- Specifies that the current isolation level is read stability.
- SERIALIZABLE
- Specifies that the current isolation level is repeatable read.
Usage notes
You can execute SET TRANSACTION only at the beginning of a transaction.