Reloading Data into DB2 API Stage

[mailravi.dw@gmail.com]

Hi All,

I am trying to load data from Sequential file to DB2 Database with the help of DB2 API stage by using update action as Insert rows without Clearing.

My file has 50,000 records. When the load was at 45,000 record the job got aborted due to some reason. Then we are reloading from scratch.(we put delete statement in Before SQL to delete all the records aer present under the perticular business date (run date)). But it is not a good solution to achieve this.

Please suggest us how to start from 45,001 record for inserts.

Thanks & Regards
Ravi

[ray.wurlod]

There's no general solution to this problem unless your job design keeps records - or interrogates the target - to determine how far it got. You need to provide that value - probably via a job parameter - to a constraint expression (in a Filter or Transformer stage).