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 / kaushik datta
You can you SAVEPOINT/ROLLBACK logic if you want to use.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why select is not preferred in embedded sql programs?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Describe major components of db2?
What is null indicator in db2?
What is table space in db2?
What are types of indexes?
What is meant by union and union all?
What is the use of predicate?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What are foreign keys in db2?
Why do chiropractors use drop table?
What is a Foreign Key?
How to find the number of rows in db2 tables?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Explain correlated sub-queries.