When using IBM utilities, RESTART(CURRENT) on the EXEC statemnt will rest

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 / s

10 Answers
58767 Views
Cap Gemini, Wipro, I also Faced
E-Mail Answers

Answer Posted / s

When using IBM utilities, RESTART(CURRENT) on the EXEC
statemnt will restart the program from the last committed
point.

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is ibm db2 used for?

1133

What is db2 purescale?

1057

How to take backup of table in db2?

1129

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1240

What os does db2 run on?

1052

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1144

What is reorg and runstats in db2?

1263

What is host variable in db2 cobol?

1136

What is meant by explain?

1198

What is explain plan in db2?

1052

What is explain in db2?

1080

How to create db2 table in mainframe?

1222

Why select is not preferred in embedded sql programs?

1355

What is alias in db2?

1113

How many databases can be created inside an instance in db2 ?

1087