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 is the physical storage length of the data types: date, time, timestamp in the db2 database?
How do I add a column to an existing table in db2?
What is package in db2 mainframe?
How can you quickly find out the # of rows updated after an update statement?
What is null value in db2?
What is the result of open cursor statement?
Can you tell me how can you find out the # of rows updated after an update statement?
How does cobol compile db2 program?
What is precompiler in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
what is utility for parm lib
Define db2 and its databases?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is cursor with hold option in db2?
What is db2 look?