Interested to Buy Any Domain ? << Click Here >> for more details...
I have a DB2 table which has 1000 rows.after udatingg first
110 rows, my job abends. Now what I have to do if I want to
restart the job next time so that it should start updating
from 111th row (without updating first 110 rows again).
- 10 Answers
- 58405 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kaushik datta
You can you SAVEPOINT/ROLLBACK logic if you want to use.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
List out the data types available.
Which is faster delete or truncate?
What is copy pending status in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Where do you specify them?
What is reorg and runstats in db2?
Why cursor is used in db2?
What are the contents of dclgen?
What is query_cache_limit?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
List out the buffer pools in db2
What is a plan and package in db2?
what is a corelated subquerry?
What is database alias db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
