Interested to Buy Any Domain ? << Click Here >> for more details...
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).
- 10 Answers
- 58452 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
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 difference between cursor and select statement?
What are the bind parameters ibm db2?
What is universal database?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How do I copy a table in db2?
What is sqlca?
What is the advantage in De-normalizing tables in DB2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Highlight all the advantages that are attached to a package.
What is db2? Explain.
What is bind in db2?
What are the various isolation levels possible?
How do you select a row using indexes in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
