Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 ?    7 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 are the two types of logging in the db2 database? Explain them.

0 Answers  


What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,


What is PRIME TABLE and what are the uses of it

1 Answers  


Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,


how to check the table is empty or not?

3 Answers   IBM,






What does reorg do in db2?

0 Answers  


Which catalog table stores referential constraints?

1 Answers  


What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  


What is explain plan in db2?

0 Answers  


wht are the restrictions for union ?

2 Answers   CTS,


Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,






Categories