REXX DB2 - Isolation level query

Hariprasad_Pargunan · New User Joined: 08 Jan 2009 Posts: 13 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.

sushanth bobby · Posted: Thu Feb 04, 2010 8:27 pm Post subject:

Hi Hari,

GuyC · Posted: Thu Feb 04, 2010 9:05 pm Post subject:

sushanth bobby · Posted: Fri Feb 05, 2010 5:07 pm Post subject:

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