Dear Friends,
If we use UR in the program for some certain queries and if the program execution is over then will it again continue with UR level?

If suppose the transaction level is of RR and im setting the transaction level to UR in the program and if once the program execution is over will it automatically switch over to RR or it will stay as UR since we have set the transaction level to UR....

I believe that the ISOLATION Level you use in your imbedded sql statement is only 'active/valid' for that query. Thus you could have two selects in your program, one with UR the other without. With RR in the bind, the one without UR will always execute as RR and the one with UR will always execute with UR.

Our Database will be in read only mode...at certain times and during those periods there are some jobs to be executed. At present these jobs are bound with the CS isolation level.......and we are planning to convert it in to UR level..................we have concern here is that whether the results retrieved will be different from CS level.......