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
- 14613 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 utility for parm lib
How to find the maximum value in a column in the db2 database?
What is query_cache_limit?
What are the rules for db2 programming?
can we view the access paths created by dbrm ? how ? thx
Explain packages.
What are concurrency issues?
How will you return the number of records in table?
How can we read records for specific member in CL? AND rpg?
What is the difference between cursor and select statement?
How do I create a view in db2?
How do I delete a table in database?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How do I add a column to an existing table in db2?
Define predicate?
