IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

DB2 Commit thru Xpediter


 
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: :: View next topic  
Author Message
kinatingopi

New User


Joined: 30 Apr 2014
Posts: 6
Location: USA

PostPosted: Wed Apr 30, 2014 4:46 am
Reply with quote

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
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2503
Location: NY,USA

PostPosted: Wed Apr 30, 2014 12:15 pm
Reply with quote

Quote:
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


You have self answered the question.
Quote:

should it wait until we come out of xpediter normally (without doing an EXIT in the middle of execution).

It really depends on COMMIT, if it is successful then changes would reflect in the DB.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2430
Location: Hampshire, UK

PostPosted: Wed Apr 30, 2014 1:23 pm
Reply with quote

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.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 692
Location: Whitby, ON, Canada

PostPosted: Wed Apr 30, 2014 5:52 pm
Reply with quote

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.
Back to top
View user's profile Send private message
kinatingopi

New User


Joined: 30 Apr 2014
Posts: 6
Location: USA

PostPosted: Wed Apr 30, 2014 11:57 pm
Reply with quote

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).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts filter COMMIT/ROLLBACK statements DFSORT/ICETOOL 13
No new posts Xpediter: STEP OVER cobol section Compuware & Other Tools 0
No new posts Commit limit for Delete query through... DB2 10
No new posts Weird test results when Xpediter is t... Compuware & Other Tools 6
No new posts Commit a DB2 Table on Unix Server and... DB2 3

Back to Top