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 / debasis
Hi Kulbhushan
We cannot use with hold option for this. With hold is used so that the cursor will not be closed even after encountered with commit.
Anybody knows this answer. Please reply.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the difference between drop table and delete table?
What is the maximum size of a char data type in db2?
How can you classify the locks in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What are the uses of db2 optimizer?
What is role in db2?
Explain what are the various isolation levels possible?
What is collection in db2 bind?
What is db2 instance?
What is netezza database?
What are the benefits of using the db2 database?
Why do we need reorg in db2?
What is the maximum length of sqlca?
How do I copy a table in db2?
What is the difference between dbm cfg and db cfg file in db2 ?