Reject in column import

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
bart12872
Participant
Posts: 82
Joined: Fri Jan 19, 2007 5:38 pm

Reject in column import

Post by bart12872 »

Hi,

I have a job with a Column import stage ; in this stage a schema file is defining and i want to reject lines having more or less than 280 bytes

My problem is : when the line is less than 280, the line is rejected (option Output in Column import Stage) but if the line is more than 280 caracters, i have the warning

-> Import consumed only 280bytes of the record's 286 bytes

and the row is not rejected.

Do you know how to reject those rows ?
any help would ba appreciated.

thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Do it prior to the Column Import stage. Perhaps a Filter stage, perhaps a Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply