Like Operator in datastage

bala_135 · Post by **bala_135** » Mon May 11, 2009 4:32 am

Hi All,

A small clarification.Is there any functions or suggestions to implement the LIKE operator in datastage.

Eg:-Select col1,col2 from table1 where col3 LIKE %ABC%.

I am converting some sql scripts to datastage jobs,the issue is I have to implement the LIKE part also in datastage because the source is a file.

Any inputs most appreciated.

Regards,
Bala.

rajendharreddy · Post by **rajendharreddy** » Mon May 11, 2009 4:37 am

In Datastage % equal to ...

nagarjuna · Post by **nagarjuna** » Mon May 11, 2009 5:51 am

You can use the same like operator in filter stage .Try that option and let us know .

bala_135 · Post by **bala_135** » Mon May 11, 2009 6:29 am

Thanks its working.We can use LIKE operator in Filter Stage.
Eg:- col3 LIKE '%ABC%'

Regards,
Bala.

chulett · Post by **chulett** » Mon May 11, 2009 6:37 am

So... resolved? If so, mark it Resolved using the button at the top of the screen please.