How to use NOT IN condition ??

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
bond88
Participant
Posts: 109
Joined: Mon Oct 15, 2012 10:05 am
Location: USA

How to use NOT IN condition ??

Post by bond88 »

I want to use NOT IN condition in Datastage. I need records which are not 'X'. (If I need records which are X, I can use filter what about NOT X).
Bhanu
Top
bond88
Participant
Posts: 109
Joined: Mon Oct 15, 2012 10:05 am
Location: USA

Post by bond88 »

We can use <> X in where condition in filter stage. (You can also use AND in where condition)
Bhanu
Top
chandra.shekhar@tcs.com
Premium Member
Premium Member
Posts: 353
Joined: Mon Jan 17, 2011 5:03 am
Location: Mumbai, India

Post by chandra.shekhar@tcs.com »

Perhaps this post might help.
Thanx and Regards,
ETL User
Top
Post Reply

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