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
- 22830 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 is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is reorg in DB2
What is the difference between spufi and qmf?
what is plan? is plan executable or package?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
how 2 resolve the -311 sqlcode
My SQL is not performing well. Describe how will you fine tune it?
What is the difference between drop table and delete table?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What are union and union all?
What is the difference between primary key & unique index ?
COBOL 
