SET CURRENT ISOLATION statement
The SET CURRENT ISOLATION statement assigns a value to the CURRENT ISOLATION special register.
This statement is not under transaction control.
Invocation
This statement can be embedded in an application program or issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared.
Authorization
None required.
Syntax
Description
The value of the CURRENT ISOLATION special register is replaced by the specified value or set to blanks if RESET is specified.
Notes
- Syntax
alternatives: The following syntax alternatives are
supported for compatibility with previous versions of Db2® and with other
database products.
- TO can be specified in place of the equal sign (=)
- DIRTY READ can be specified in place of UR
- READ UNCOMMITTED can be specified in place of UR
- READ COMMITTED is recognized and upgraded to CS
- CURSOR STABILITY can be specified in place of CS
- REPEATABLE READ can be specified in place of RR
- SERIALIZABLE can be specified in place of RR