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
- 14893 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 difference between oracle and db2?
what are bind concepts in db2 cobol?
How can you count the number of rows from a table tab?
What does sqlcabc has?
Is schema the same as database?
What is nvl in db2?
What are union and union all?
What do you mean by rollback?
Give the name of some fields form sqlca.
Which are the db2 tools to protect integrity of the database?
What is db2 look?
What is performance tuning db2?
What is bind package and plan in db2?
What is the physical storage length of the data types date, time, and timestamp?
What is coalesce in db2?
