Interested to Buy Any Domain ? << Click Here >> for more details...
what is commit & rollback? When and where is used while
compiling a cobol-db2 program?
- 2 Answers
- 22847 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
Why might full image copies be faster to implement than an incremental image copy?
What is blu acceleration in db2?
How does one remove entries from the SCT02 table?
Explain the EXPLAIN statement?
The only place of VSAM KSDS in DB2 is?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
How to resolve -818 sql code in DB2?
What are the Isolation levels possible ?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
COBOL 
