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?