what is commit & rollback? When and where is used while
compiling a cobol-db2 program?

Answers were Sorted based on User's Feedback



what is commit & rollback? When and where is used while compiling a cobol-db2 program?..

Answer / naveen

Commit is used when the changein the record is to be made
permanent.
It is coded in Cobol-DB2 program after some frequency of
record is processed.

Rollback is Issued by the DB2 system/will be coded by User
when it any abends/errors occurs while processing.

Is This Answer Correct ?    8 Yes 2 No

what is commit & rollback? When and where is used while compiling a cobol-db2 program?..

Answer / karthikeyan

Commit:After end of the every permanent Transaction we used
commit.This is most probably used used for record tracking
purpose in the issue log.

Rollback:If any error occur during ur transaction (ex: any
data error) ur procedure will autoimatically call the
rollback procedure and it rollback all the stored record
from the table.u want to use the save point concept while
using the rollback.

Is This Answer Correct ?    8 Yes 4 No

Post New Answer

More DB2 Interview Questions

What can the Locate option of the Repair Utility accomplish?

2 Answers  


cursor with hold explain ?

1 Answers   Verizon,


WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,


Which isolation level provides maximum concurrency?

0 Answers  


How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,


How is deadlock resolved?

0 Answers  


How can you count the number of rows from a table tab?

0 Answers  


What is clone table?

0 Answers  


What are the four lockable units for DB2?

1 Answers  


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  


What is db2 look?

0 Answers  


can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,


Categories