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 / krishna
declare the cursor with withhold option and we restart the
process from 111 record
| Is This Answer Correct ? | 3 Yes | 12 No |
Post New Answer View All Answers
What parameters are used to control the free space in DB2?
Which isolation level provides highest data integrity?
What is dbrm in db2 database?
What is a db2 tablespace?
List out the buffer pools in db2
B37 abend during spufi?
How connect db2 database to datastage?
What are foreign keys in db2?
What types of tables are there in the db2 database?
What is deadlock in db2?
What is the reason behind not using select * in embedded sql programs?
How to find schema of a table in db2?
What's The Percentage Free Space ?
Discuss about db2 bind?
How many databases are there?