DSXchange

Dear Experts,

The DataStage Server job stops at some point, (after loading say 50000 records) and I rerun the job after some time.

How can I reload from the left out record (in this case 500001)? Can anybody please help me out with this query?

Thanks & Regards

Lavanya

Hi Lavanya,

if you know what you have already loaded and find a rule where to restart you can do it.

You can also change your job and use the target as lookup and don't reload those rows you have already loaded.

Best is to analyse why your job stopped and to prevent this in future.

A quick patch would be to make @INROWNUM > 500000 a constraint.