Isolation level can be set in windows at the Application call
level to ODBC or ADO, so that it is part of the executable at run time and
can have logic wrapped around it. You do not have to change the db2cli.ini
file.
The
ODBC methods are in DB2 documentation.
The
ADO/OLEDB links can be found in http:/msdn.microsoft.com
-----Original Message-----The Isolation level can work at the statement level pnly with the
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 7:34 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2EUG: setting isolation level in sqr
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
