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.

Thanks
give_me_more
 
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

Hello,

There is an implied commit when the process ends normally. An abend causes an automatic rollback.
Hope this helps,
d.sch.
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
    Replies
    Views
    Last post