Change Isolation Level

Changes the way that DB2® isolates data from other processes while a database is being accessed. This API can only be called from a REXX application.

Authorization

None

Required connection

None

REXX API syntax

CHANGE SQLISL TO {RR|CS|UR|RS|NC}

REXX API parameters

RR

Repeatable read.

CS

Cursor stability. This is the default.

UR

Uncommitted read.

RS

Read stability.

NC

No commit.