Job has been aborted after some rows..?

[balaya.ds]

I have a datastage job which is having 900 records.

my qst is the job has been aborted after 400 records. i want to start from 401 record ?

how to do that..?

_________________

[Sainath.Srinivasan]

Delete the first 400 from the source.

[amit101here]

what stages are you using ?
...If you are using sequential file stage..there is property called cleanup on failure..set this as true....and you dont have to worry about this....everytime job is failed, records will be cleaned up...and next run will load from scratch again....

[chulett]

That's a new one on me.

The next run will always be "from scratch" unless you specifically code it to be otherwise.

[vivekgadwal]

If the data volume is what you mentioned here, then I would do an "all or nothing" commit in the database.