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
What is bufferpool in db2?
Can there be more than one cursor open for any program?
What is ibm db2 database?
Explain db2.
Define predicate?
What does db2 stand for?
Mention some fields that are a part of sqlca.
How does db2 sample database connect?
How to find the number of rows in a db2 table?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the use of reorg in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What does a deadlock mean in DB2?
How do I add a column in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?