The Isolation level can work at the statement level pnly with the
DB2 V.7.1 Fixpack 3, which is V.7.2.
Also, UR can be used into the SELECT, INSERT, UPDATE and DELETE statement

These new features comes into the DB2 release notes V.7.2
You can access this information at:
DB2 V7.2 release Notes

Use WITH
Specifies the isolation level at which the fullselect is executed.
RR Repeatable Read
RS Read Stability
CS Cursor Stability
UR Uncommitted Read

Reply via email to