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

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  


What are some characteristics of columns that benefit from indexes?

1 Answers  


how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,


What is dbrm? When it will be created?

0 Answers  


What is cursor stability in db2?

0 Answers  






What happens in bind step in a db2 program?

0 Answers  


how to fetch multiple records without using cursor

14 Answers   HCL,


What else is there in the PLAN apart from the access path?

1 Answers  


What is db2 optimizer?

0 Answers  


What is a cursor in programming?

0 Answers  


What does CURRENTDATA option in bind indicate

1 Answers   IBM,


How would one remove old reorg information from the DB2 catalog?

2 Answers  


Categories