what is commit & rollback? When and where is used while
compiling a cobol-db2 program?
- 2 Answers
- 22365 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 Skeleton cursor table (SKCT)?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is the difference between group by and order by?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
What is a db2 cursor?
What is difference between *omit and *nopass?
What is dbrm? What it contains? When it will be created?
What type of database is db2?
What are the four lockable units for DB2?
What is database manager in db2?
Where could you look if you had a question about whether a column has been defined as an index?
What is the difference between CS and RR isolation levels?
COBOL 
