SET ISOLATION LEVEL
SET ISOLATION LEVEL {READ COMMITTED | REPEATABLE READ | SERIALIZABLE}
Access requirements
Database user
Usage
Use the SET ISOLATION LEVEL statement to specify the transaction isolation level.
The SET ISOLATION LEVEL statement takes effect from the next transaction (that is, after the next COMMIT WORK statement).
For more details about isolation levels, see
Controlling transaction isolation levels.
Example
SET ISOLATION LEVEL REPEATABLE READ;
Go up to