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
Comment whether the cursor is closed during commit or not.
How does cobol compile db2 program?
How to view db2 table structure?
What is view db2?
What is the use of value function?
What is data manager?
Explain about mirror activator disk mirroring?
i want to maintain uniqueness on pdf without make lf??????????
What are the 2 sqlcodes that are returned?
What is a db2 package?
Name the various locking levels available?
How to find primary key of a table in db2?
What is the difference between plan and package in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
My sql statement select avg(salary) from emp yields inaccurate results. Why?