Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14190 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
What is the use of runstats in db2?
what is the responsibility of the construction superintendent
How to execute stored procedure in db2 command editor?
What is ibm db2 database?
What is concurrency?
What is bind in db2?
What is a buffer in memory?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is a db2 collection?
what is the sqlcode -501
How do you simulate the explain of an embedded sql statement in spufi/qmf?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the function of logging in the db2 database?
What is plan in cobol db2?
What is package in db2 mainframe?
