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 / ramakrishna javvaji
create a temporary table and write every row before
processing and delete it after it is processed.
In case of abend you will have the row at which it abended
in the temporary table. you can now drive the process based
on this info.
correct me if i am wrong.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is a db2 cursor?
What is explain plan in db2?
What is clone table?
Which command is used to remove all rows from a table?
What is cloudant database?
What is difference between isnull and coalesce?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Define sqlca.
What action db2 takes when a program aborts in the middle of a transaction?
Is ibm db2 open source?
What is the maximum size of a char data type in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is db2 instance?