what is commit & rollback? When and where is used while
compiling a cobol-db2 program?
- 2 Answers
- 23122 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 |
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?
what is the role of the cursor in db2?
select 100 records from million records ?
What is rebind in db2?
How is a typical DB2 batch program executed ?
How do you Load a table ?? and what is Load replace ?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What is host variable in db2 cobol?
What is a page in db2?
What are common abends
what is a trigger and types of triggers
What is db2?
COBOL 
