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 / basu and monty.
when u say that in first paragraph we need to read the
temporary table, what happens for the first time when the
temp table is read.. as it will be an empty table...
?
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Mention the various locks that are available in db2.
How to rename a table in DB2 ?
What is difference between isnull and coalesce?
What is the clustering index in the db2 database?
How does coalesce work?
What is the connection string to connect to the DB2 Database ?
What is the difference between oracle and db2?
What is ibm db2 used for?
Which component is responsible for db2 startup and shutdown?
What is the use of runstats in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the latest version of ibm db2?
Explain what are the various isolation levels possible?
Explain in brief how does db2 determine what lock-size to use?
What is the maximum size of a char data type in db2?