what is commit & rollback? When and where is used while
compiling a cobol-db2 program?
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 are the Isolation levels possible ?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
can i code union in cobol-db2 pgm ?
How do I add a column to an existing table in db2?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
can we update the table by using cursors can anyone post the query?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What is ibm db2 used for?
what is the maximum number of tables that can be joined ?
what are bind concepts in db2 cobol?
Can you search give an array in the WHERE clause of a db2 query?
Where are plans stored?