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


Please Help Members By Posting Answers For Below Questions

B37 abend during spufi?

980


What is the physical storage length of timestamp data type?

644


Is it possible to create an Instance in DB2 using DB2 Control Center ?

627


What is the picture clause of null indicator variable?

688


How can we retrieve the total number of records in RPG & CLLE?

194






Before you give the explain statement, what are the prerogatives?

579


What is the role of the data page in the db2 database?

585


What is a db2 collection?

605


what is utility for parm lib

1873


What does a deadlock mean in DB2?

651


What's The Error Code For Unique Index Voilation?

648


What is cursor stability in db2?

810


What is a bind card?

679


Explain about open switch business continuity software?

563


What is difference between isnull and coalesce?

618