sql loader job status

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kirankota79
Premium Member
Premium Member
Posts: 315
Joined: Tue Oct 31, 2006 3:38 pm

sql loader job status

Post by kirankota79 »

i am truncating and loading a 5 million table. It loaded all except 200 rows with bad data. and enabled all the constraints in the end. but the job status shows as aborted and refers to see the log file.

I want to know if even a single row is rejected , does it shows as aborted or is there anything else. In the log file i see only the rejected rows.
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

Yes, even if a single row is rejected , it shows as aborted
Post Reply