DB2 Commit thru Xpediter

kinatingopi · New User Joined: 30 Apr 2014 Posts: 6 Location: USA

Hi,

I am trying to execute a DB2 COBOl program thru xpediter and seeing that the commits are done even though I exit the xpediter in the middle of execution. Does xpediter commit a record as soon as the SQL is executed or should it wait until we come out of xpediter normally (without doing an EXIT in the middle of execution).

Thanks, Gopi

Rohit Umarjikar · Posted: Wed Apr 30, 2014 12:15 pm

Nic Clouston · Posted: Wed Apr 30, 2014 1:23 pm

Xpediter does not COMMIT. It traces your program. Your program does the COMMIT. If it doesn't do a COMMIT then you should read up about COMMIT as used/not issued in a program.

don.leahy · Posted: Wed Apr 30, 2014 5:52 pm

The normal behaviour of any DB2 program, whether running under Expeditor or not, is to Commit changes when the program terminates normally.

If you do not want your changes committed you need to take some action during your debugging session, such as forcing an Abend.

kinatingopi · New User Joined: 30 Apr 2014 Posts: 6 Location: USA

Thanks everyone for the reply.. It was my bad. I shud have to done a QUIT from xpediter instead of 'EXIT' as the former is abnormal exit, but later is normal exit (which caused the commit to occur).