Suppose we are doing transaction in a table and abend happened in
between. Suppose i have completed the transaction upto X rows and
I want to start the transaction again where the abend happened. I
don't want to do the transaction from the first record. Then what
i have to do.
Answer Posted / k.pratap
using flags.we correct that one.
first insert flag in u r table.
first write in u r cursor declaration with flag=0.
first take flag is 0.
after read the record.if record is successfully reading update flag is 1.ok.
if abend coming automatically rollback applied.
next the cursor going where the flag=0.it means it not successfully updated.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can you classify the locks in db2?
What are the different types of base tables?
How will you return the number of records in table?
What is a cursor in programming?
Mention the definition of cobol in varchar field.
What is the maximum size of varchar data type in db2?
What is the difference between nvl and coalesce?
How to check table size in db2 sap?
Explain about open switch business continuity software?
What does reorg do in db2?
Explain about rct.
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
what is the responsibility of the construction superintendent
What are the two types of logging in the db2 database? Explain them.
What is isolation level in db2?