MVSFORUMS.com

psmadhusudhan · Beginner Joined: 28 Nov 2006 Posts: 143 Topics: 48

Hi all,

I have one doubt. I have a cobol-db2 program with many sql's (select, update etc). As per my knowledge when we bind a cobol-db2 program the isolation level given as bind parameter will be taken default for all sql's in the program.

I want to know whether is it possible to specify different isolation levels to different sql's like UR for select, CS for update sql's. Please help me with my doubt.
_________________
Thanks
Madhu Sudhan

kolusu · Posted: Mon Mar 10, 2008 10:27 am Post subject:

psmadhusudhan,

Code your SELECT statements with WITH UR clause and it will solve your problem
_________________
Kolusu
www.linkedin.com/in/kolusu

psmadhusudhan · Beginner Joined: 28 Nov 2006 Posts: 143 Topics: 48

Thanks kolusu. As per your answer I guess we can directly specify the isolation at each sql statement, and this will override the isolation level given at bind parameter. Is it true.
_________________
Thanks
Madhu Sudhan