RE: DB2EUG: setting isolation level in sqr

[Vilas, Ajith (USPC.PCT.Hopewell)]

"with UR" syntax is valid only in version 7.2 of AIX UDB. You can set the isolation 
level in db2cli.ini file (this is a global setting). 

[your data source name]
autocommit=0
TXNISOLATION=1

Regards,
Ajith

-----Original Message-----
From: Kurt Sahlberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 2:06 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2EUG: setting isolation level in sqr


Hi Leigh,
you can code "with ur" at the statement level.
HTH
Kurt


>>> [EMAIL PROTECTED] 08/23/01 11:09AM >>>
Hi -
     We have dynamic sqr code that needs to run at isolation level UR.
(AIX, db2 5.2, sqr , 4.3.2).  Issuing the set isolation level command as a
system call within sqr does not reset the isolation level.

Does anybody know how to force the isolation level to UR at the sqr or
statement level ?

     Thank you for your help !     Leigh.


=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] 
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod 



=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod



=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod