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 / s
When using IBM utilities, RESTART(CURRENT) on the EXEC
statemnt will restart the program from the last committed
point.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Explain packages.
Define db2 and its databases?
Highlight all the advantages that are attached to a package.
What do you mean by cursor?
What is reorg and runstats in db2?
Why do we use cursor?
What is a db2 cursor?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How to find the maximum value in a column in the db2 database?
What is rebind in db2?
Explain what are the various isolation levels possible?
What does db2 stand for?
What is the max length of sqlca?
define clustering index.
What is cloudant database?