View previous topic :: View next topic
|
Author |
Message |
Hariprasad_Pargunan
New User
Joined: 08 Jan 2009 Posts: 20 Location: Chennai
|
|
|
|
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. |
|
Back to top |
|
![](templates/skyLineGrey/images/spacer.gif) |
sushanth bobby
Senior Member
![](images/avatars/739181097521c4a1d06974.jpg)
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Hari,
Quote: |
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. |
SET CURRENT PACKAGESET is used to specify collection names, it is not even a bit related to isolation levels.
Sushanth |
|
Back to top |
|
![](templates/skyLineGrey/images/spacer.gif) |
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
sushanth bobby wrote: |
Quote: |
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. |
SET CURRENT PACKAGESET is used to specify collection names, it is not even a bit related to isolation levels.
|
It is for rexx |
|
Back to top |
|
![](templates/skyLineGrey/images/spacer.gif) |
sushanth bobby
Senior Member
![](images/avatars/739181097521c4a1d06974.jpg)
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hari,
Thank You GuyC for that.
1) Will the isolation level "UR" be in effect for all the select queries whatever I use in my REXX code?
Yes
2) We can omit this option and provide "WITH UR" clause in the select queries?
Yes
Sushanth |
|
Back to top |
|
![](templates/skyLineGrey/images/spacer.gif) |
|