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
How can you do the explain of a dynamic sql statement?
Can you tell me how can you find out the # of rows updated after an update statement?
Name the lockable units in DB2?
What are union and union all?
What is a buffer in memory?
What is the default page size of buffer pools?
What os does db2 run on?
What is db2 look?
can we view the access paths created by dbrm ? how ? thx
When the like statement is used?
What is the physical storage length of time data type?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Can we update view in db2?
Comment whether the cursor is closed during commit or not.
Define buffer pool.