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 are catalog tables in db2?
What is the difference between cursor stability and repeatable read isolation levels?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is runstats utility in db2?
What is bufferpool in db2?
What is the function of logging in the db2 database?
Define declaration generator (dclgen).
What is dbrm in db2 database?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is a db2 table?
Name the various locking levels available?
What is the meaning concurrency in the db2 database?
List down the types of triggers in the db2 database?
What is db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?