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
- 23051 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 |
How to create db2 table in mainframe?
Name some fields from SQLCA
How do I import data from excel to db2?
What are data types?
What is the syntax for seeing the columns and data types of a table in the db2 database?
what is a plan and how do you refer the plan in the program?
What is the max length of sqlca?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
Explain about dbrm.
Which components manage deadlocks in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
COBOL 
