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
What are the various isolation levels possible?
How do I copy a table in db2?
What do you mean by cursor?
Explain about rct in db2?
What is cobol db2?
Explain correlated sub-queries.
What are the benefits of using the db2 database?
What is package in cobol db2?
Which component is responsible for processing sql statements and selecting access paths?
Is db2 a database?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the information associated with sysibm.syslinks table?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What are the two types of logging in the db2 database? Explain them.
What is a Foreign Key?