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
- 22823 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 |
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is cursor stability?
How to rename a table in DB2 ?
what are the SQL codes u freequently got?
What is null indicator in db2?
How would you find out the total number of rows in a db2 table?
What is reorg in DB2
What is db2 catalog database?
What is a NULL value? What are the pros and cons of using NULLS?
What is the difference between TYPE 1 index & TYPE 2 index
How will fetch last 5 rows from table in db2
What is bufferpool in db2?
COBOL 
