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
- 22937 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 |
Can we insert update delete in view?
Are views updateable?
wht steps we need will coding cobol and db2 pgm ?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
What is the function of the Data Manager?
Define db2.
What information is used as input to the bind process?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
How to resolve deadlock issue
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
Mention data types used in db2 ?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
COBOL 
