how to use 'IN' function in datastage

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
bob7027
Participant
Posts: 22
Joined: Wed Oct 03, 2012 2:49 pm
Location: United States

how to use 'IN' function in datastage

Post by bob7027 »

Hello every one!!.

how can i use 'IN' function in datastage transformer.
Advance Thanks.
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

By "IN" do you mean the SQL DML type, i.e. "WHERE cola IN (1,2,3)"?
Top
bob7027
Participant
Posts: 22
Joined: Wed Oct 03, 2012 2:49 pm
Location: United States

Post by bob7027 »

Thanks For the reply ArndW

Yes
Top
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

You can use index function. but if you have two values where one is a substring of another then it is a bit tricky, You can try adding a leading and trailing delimiter.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Top
Post Reply

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