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

Read syntax diagramSkip visual syntax diagramSETCURRENTISOLATION =URCSRRRSRESET

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