DB2 10.5 for Linux, UNIX, and Windows

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