Question asked at Steria

Question asked at Steria

Postby give_me_more » Thu May 20, 2010 6:36 pm

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.

Posts: 5
Joined: Tue May 11, 2010 8:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Question asked at Steria

Postby dick scherrer » Thu May 20, 2010 11:33 pm


There is an implied commit when the process ends normally. An abend causes an automatic rollback.
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Return to Interview Questions


  • Related topics
    Last post