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
58497 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

Mention data types used in db2 ?

1169

What is cloudant database?

1104

What is schema in db2?

1028

What is the usage of open cursor command?

1110

What is null value in db2?

1033

Which command is used to connect to a database in DB2 ? Give the Syntax.

1116

What is the physical storage length of date data type?

1262

What does db2 plan contain?

1031

What is host variable in db2 cobol?

1092

What is package in db2 mainframe?

995

What is a db2 tablespace?

1079

What is meant by union and union all?

1018

Why do we use cursor?

1109

What is phantom read in db2?

1172

What are the full forms of spufi and dclgen and why are they used?

1097