can switch stage filter the null values?

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
vasam
Participant
Posts: 30
Joined: Wed Nov 04, 2009 5:06 am

can switch stage filter the null values?

Post by vasam »

Hi All,

I have a requirement which is i am getting some status like COMT,PEND,FAIL,NULL from my source file. what i need to do is i have to filter the status and send it to each file.

so i had used one switch stage to filter the status, but NULL status is not recognizing in SWITCH stage?

If any NULL comes i have to send this entire record into one file.

how can i do this?

suggest me.

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

Post by ray.wurlod »

Not possible.

Use a Filter stage or 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