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

        .-CURRENT-.             .-=-.              
>>-SET--+---------+--ISOLATION--+---+--+-UR----+---------------><
                                       +-CS----+   
                                       +-RR----+   
                                       +-RS----+   
                                       '-RESET-'   

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 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