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


Please Help Members By Posting Answers For Below Questions

What's The Error Code For Unique Index Voilation?

648


What is a system catalog table in db2?

582


What is copy pending and check pending in db2?

570


What is an instance database?

598


Which component is used to execute the sql statements?

617






Which isolation level provides highest data integrity?

593


What is package in cobol db2?

698


How would the varchar column remarks defined?

633


What is check constraint in db2?

603


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1646


Mention data types used in db2 ?

671


My sql statement select avg(salary) from emp yields inaccurate results. Why?

639


Why do we need reorg in db2?

558


What is a buffer in memory?

596


What is null indicator in db2?

602