Page 1 of 1

Question asked at Steria

PostPosted: Thu May 20, 2010 6:36 pm
by give_me_more
In a DB2/COBOL progam, we are updating a table and somehow we miss to code COMMIT inside the program. Will the table be updated when the program executes successfully? Or basically he wanted to ask what is the default when no commit is explicitly specified

My answer): When program executes successfully then COMMIT will happen on its own. Hence the table will be udpated.

____________

My confusion: I used to think that permanent updates take place when we explicity write COMMIT inside the program. Without coding COMMIT too it works ??? Really a news to me ...

Please throw some light on this.

Thanks

Re: Question asked at Steria

PostPosted: Thu May 20, 2010 11:33 pm
by dick scherrer
Hello,

There is an implied commit when the process ends normally. An abend causes an automatic rollback.