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.