Hariprasad_Pargunan
New User
Joined: 08 Jan 2009 Posts: 20 Location: Chennai
|
|
|
|
Posted: Thu Feb 04, 2010 10:49 am Post subject: REXX DB2 - Isolation level query
--------------------------------------------------------------------------------
Hi,
I have written a REXX DB2 program to fetch few rows from the DB2 tables.
Normally, I use "WITH UR" option in all my select queries. Since in REXX we have an option called
"EXECSQL SET CURRENT PACKAGESET='DSNREXUR'" to set the isolation level I have used the same in my REXX program.
My question is, I am setting the above isolation level before I proceed with the select queries so
1) Will the isolation level "UR" be in effect for all the select queries whatever I use in my REXX code? or
2) We can omit this option and provide "WITH UR" clause in the select queries?
Could you please throw some light on this. |
|