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
What's The Error Code For Unique Index Voilation?
What is a system catalog table in db2?
What is copy pending and check pending in db2?
What is an instance database?
Which component is used to execute the sql statements?
Which isolation level provides highest data integrity?
What is package in cobol db2?
How would the varchar column remarks defined?
What is check constraint in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Mention data types used in db2 ?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Why do we need reorg in db2?
What is a buffer in memory?
What is null indicator in db2?