DSXchange

Hello every one!!.

how can i use 'IN' function in datastage transformer.
Advance Thanks.

By "IN" do you mean the SQL DML type, i.e. "WHERE cola IN (1,2,3)"?

Thanks For the reply ArndW

Yes

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.