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

What is the use of with ur in db2?

777


i want to maintain uniqueness on pdf without make lf??????????

1876


What is rebind in db2?

759


What is clone table?

771


What type of database is db2?

703






What is the result of open cursor statement?

803


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1825


is it compulsory commitment control in journal?

2180


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1895


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

837


What is reorg?

803


What is db2 plan table?

801


How do I create a view in db2?

772


What is check constraint in db2?

792


What is the physical storage length of the data types date, time, and timestamp?

838