DataStage Server Job - Reload from leftout records

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Lavanya Srinivasan
Participant
Posts: 20
Joined: Fri Sep 22, 2006 7:14 am

DataStage Server Job - Reload from leftout records

Post by Lavanya Srinivasan »

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
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

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.
Wolfgang Hürter
Amsterdam
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

A quick patch would be to make @INROWNUM > 500000 a constraint.
Mamu Kim
Post Reply