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.
- 9 Answers
- 11851 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 is host variable?
What is table space in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to connect to db2 database from windows command line?
How to check sequence on a table in db2?
What is a bind card?
What is cursor in dbms?
How can record locking be achieved in those DB2 versions which do not support it?
Comment whether the cursor is closed during commit or not.
How can you classify the locks in db2?
List out the buffer pools in db2
What is the physical storage length of timestamp data type?
What is cursor with hold option in db2?
What is a db2 table?
What are the prerogatives?
