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 do you mean by storage group (stogroup)?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is a db2 table?
What does reorg do in db2?
How to check sequence on a table in db2?
Can you use max on a char column?
How do I create a view in db2?
What is the picture clause of null indicator variable?
When reorg is used?
What is db2 instance?
What is the difference between plan and package in db2?
Define buffer pool.
How do we specify index to include or not during bind process.
what are bind concepts in db2 cobol?
what is db2 restart?