|
View previous topic :: View next topic
|
| Author |
Message |
HARIBHARAT
New User
Joined: 05 Jul 2006
Posts: 65
Location: pune
|
|
|
|
| how to change isolation level cobol-db2 program |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi Haribharat,
Give it in your bind card
e.g
DSN SYSTEM(DB2S)
BIND PACKAGE(IMS2) -
MEMBER(PGM- NAME) -
QUALIFIER(BTS07) -
ACTION(REPLACE) -
VALIDATE(RUN) -
SQLERROR(NOPACKAGE) -
ISOLATION(CS) -
FLAG(I) -
RELEASE(COMMIT) -
EXPLAIN(NO) |
|
| Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark
|
|
|
|
If you want to change the isolation level for few queries in the program to say UR. then just mentioned the isolation level in the sql query.
The isolation level specifed in the query overrides the IL for that query given at bind time. |
|
| Back to top |
|
|
|
|
