declare the cursor with withhold option and we restart the process from 11

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).

Question Posted / krishna

10 Answers
58061 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

Please Help Members By Posting Answers For Below Questions

What parameters are used to control the free space in DB2?

1012

Which isolation level provides highest data integrity?

1043

What is dbrm in db2 database?

1035

What is a db2 tablespace?

1002

List out the buffer pools in db2

1023

B37 abend during spufi?

1405

How connect db2 database to datastage?

1190

What are foreign keys in db2?

1037

What types of tables are there in the db2 database?

1008

What is deadlock in db2?

1021

What is the reason behind not using select * in embedded sql programs?

1047

How to find schema of a table in db2?

953

What's The Percentage Free Space ?

1158

Discuss about db2 bind?

1052

How many databases are there?

992