IN Clause in Filter Stage

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
mkkgupta
Premium Member
Premium Member
Posts: 17
Joined: Thu Jan 24, 2008 10:13 pm

IN Clause in Filter Stage

Post by mkkgupta »

HI,

I saw previous post related to IN however it says we have only ability to chk single char.

I need to check my email host around 30 -40 host names like
email_host in ( 'net','com','org')
fyi. planning to do a lookup by putting all those 30-40 host names in a file.

is there any chance to use IN operator in DS?

thank you,
Kiran
Regards
Kiran
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

No, but you could use a Lookup.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”