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 / sridhar
The way handle this is to mmaintain a seperate table in the
database with the columns like transaction id and key for
abend. Whenever abend happens the key and transaction type
has to be written to that table. The embeded sql where
clause has to be written in such way that it will allways
pick up the key from that table with >= option. If no key
is available then the where clause should be populated with
the key program has asked for.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which component is responsible for processing sql statements and selecting access paths?
What do you mean by cursor?
When the like statement is used?
Why do we need reorg in db2?
What is db2 bind?
What is dbrm?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the difference between bind and rebind in db2?
Explain the function done by data manager?
What is db2 bind process?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the clustering index in the db2 database?
What is a trigger in the db2 database?
When reorg is used?
What is db2 catalog database?