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 |
For Read Stability locks are not applicable for phantoms, What is Phantoms?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
what is Runstats? Whem will u choose to runatats?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
How to get Top 10 Salaries from a Table
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
Give some example of statistics collected during RUNSTATS?
How is the SUBSTR keyword used in sql?
What do you need to do before you do EXPLAIN?
What is meant by dclgen?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
What is the default page size of buffer pools?