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
58444 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 does db2 blu stand for?

1167

What is drop table?

1012

What is cloudant database?

1101

What is db2 and what is the use of db2 optimizer?

1069

What is a buffer in memory?

1060

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1062

Which isolation level provides maximum concurrency?

1153

What does sqlcabc has?

1058

What is difference between alias and synonym in db2?

1143

How many types of page locks can be held in db2?

1044

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1149

What is catalog database in db2?

1166

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2853

What is db2 look?

1027