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 / basu and monty.

when u say that in first paragraph we need to read the
temporary table, what happens for the first time when the
temp table is read.. as it will be an empty table...
?

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get the ddl of a table in db2?

679


What is a db2 tablespace?

602


How to find primary key of a table in db2?

617


What is cloudant database?

645


What is coalesce in db2?

682






How would the varchar column remarks defined?

640


How to run db2 command in windows?

654


What is a db2 table?

597


Mention the various locks that are available in db2.

618


What is the syntax for seeing the columns and data types of a table in the db2 database?

578


What is an instance in db2?

567


What is a Foreign Key?

660


What are db2 tables?

649


What is reorg?

619


What is the physical storage length of the data types date, time, and timestamp?

612