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
58065 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 the use of predicate?

985

What are the 2 sqlcodes that are returned?

1131

How can you count the number of rows from a table tab?

1043

How do you concatenate the firstname and lastname from emp table to give a complete name?

1016

What is db2 look?

971

What is the difference between cursor stability and repeatable read isolation levels?

1116

What is the role of data manager in the db2 database?

1053

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1057

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

1034

What are foreign keys in db2?

1037

What is db2 command?

965

What is lock escalation in db2?

969

What is ibm db2 connect?

933

What is declare cursor?

1046

How to execute stored procedures?

1069