Oracle function IN equivalent in Datastage

veerabusani185512 · Post by **veerabusani185512** » Wed Jun 15, 2011 7:21 am

Hi,

Is there any function available in DS equivalent to Oracle IN or NOTIN functions?

I need to implement below logic in my job.
If the column PRODUCT value is IN ('AA','BB','CC','DD','EE','FF'), then the output is 1 else 0.can you please suggest any ideas?

Thanks & Regards,
Veera.

chulett · Post by **chulett** » Wed Jun 15, 2011 7:30 am

That would be the Index() function, something you can search for as its use for this purpose has been documented here quite a bit.

nani1974 · Post by **nani1974** » Wed Jun 15, 2011 2:55 pm

Even You can use 'If Then Else' in Transformer and get the result.

chulett · Post by **chulett** » Wed Jun 15, 2011 4:42 pm

True... but that would be more of an alternative rather than an equivalent.