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).
Answer Posted / neeti
Can anybody tell me how can I put these checkpoints in amy
application pgm. What changes will be neede in my pgm as
well as my JCL?
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Comment whether the cursor is closed during commit or not.
What is consistency token in db2?
What os does db2 run on?
Which command is used to remove all rows from a table?
How does a cursor work?
What is the difference between plan and package in db2?
Where do you specify them?
What is access path in 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 ?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How many databases are there?
What is netezza database?
How is deadlock resolved?
What are the 2 sqlcodes that are returned?
How do you pull up a query which was previously saved in qmf?