DSXchange

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.

In Datastage % equal to ...

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

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

Regards,
Bala.

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