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
- DB2EUG: setting isolation level in sq... lflynn
- Re: DB2EUG: setting isolation le... Kurt Sahlberg
- RE: DB2EUG: setting isolation le... Vilas, Ajith (USPC.PCT.Hopewell)
- Re: DB2EUG: setting isolation le... Raghu Raman
- Re: DB2EUG: setting isolation le... MCELI7890
- RE: DB2EUG: setting isolation le... MCELI7890
- RE: DB2EUG: setting isolation le... Fortier, Christi (USPC.PCT.Hopewell)
