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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Highlight all the advantages that are attached to a package.

615


Why select is not preferred in embedded sql programs?

697


What is the use of with ur in db2?

602


What are union and union all?

529


How to view db2 table structure?

579






What is the difference between spufi and qmf?

631


Define predicate?

630


What os does db2 run on?

565


When reorg is used?

661


How is a typical db2 batch pgm executed?

630


What is the clustering index in the db2 database?

571


How to run db2 command in windows?

631


Why do we use cursor?

582


Can we update view in db2?

547


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1225