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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I delete a table in db2?

653


Is db2 a database?

578


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

652


What is deadlock in db2?

589


What is the difference between cursor stability and repeatable read isolation levels?

692






What are db2 objects?

646


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

722


What is load replace in db2?

564


What is a collection in db2?

586


When reorg is used?

685


What is db2 look?

590


What is check constraint in db2?

617


What is ibm db2 connect?

583


What is sqlca?

629


What is the use of reorg in db2?

614