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).

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

How to view db2 table structure?

594


What is clone table?

592


Which is faster delete or truncate?

681


Can you tell me how can you find out the # of rows updated after an update statement?

612


How to find the maximum value in a column in the db2 database?

613






What is db2 bind process?

760


How to find the number of rows in db2 tables?

618


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

604


How to restart a DB2 program?

1367


How can we retrieve the total number of records in RPG & CLLE?

203


Explain db2.

620


How to check sequence on a table in db2?

601


How do I import a csv file into db2?

563


What is a dbrm in db2?

578


How do you eliminate duplicate values in db2?

688