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 are the bind parameters ibm db2?
How to create backup table in db2?
What action db2 takes when a program aborts in the middle of a transaction?
How do I optimize a query in db2?
What is check constraint in db2?
What does db2 stand for?
What is the usage of open cursor command?
List out the three types of page locks that can be held.
What is dbrm? What it contains?
How do we specify index to include or not during bind process.
Why do chiropractors use drop table?
What is difference between isnull and coalesce?
What is isolation level in db2?
Define declaration generator (dclgen).
Why do we need reorg in db2?