You can you SAVEPOINT/ROLLBACK logic if you want to use.

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 / kaushik datta

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

Answer Posted / kaushik datta

You can you SAVEPOINT/ROLLBACK logic if you want to use.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the max length of sqlca?

1157

How do you pull up a query which was previously saved in qmf?

1099

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2006

What is the syntax for creating a table in the db2 database?

1058

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

977

What is meant by explain?

1062

Which isolation level provides maximum concurrency?

1089

How can you classify the locks in db2?

1032

Explain about cursor stability?

981

How do I add a column to a table in db2?

1049

What is the difference between drop table and delete table?

1117

What is db2 catalog database?

987

What is a db2 schema?

1173

How do I start db2 in windows?

1021

What is with ur in db2?

1242