Like operator convertion in DataStage

madsongtel · Post by **madsongtel** » Sun Apr 17, 2011 9:12 am

Hi All,

My requirement is to convert like operator logic into datastage.
below is my requirement

Input_colname like '%F%G%E%Z%'

Please help me out, Thanks in advance.

Ravi.K · Post by **Ravi.K** » Sun Apr 17, 2011 10:24 am

Use Index Function

chulett · Post by **chulett** » Sun Apr 17, 2011 10:29 am

Probably better suited to the 'matches' function.

jastichoudaryuu · Post by **jastichoudaryuu** » Mon Apr 18, 2011 12:52 am

we can do it in filter stage as well

madsongtel · Post by **madsongtel** » Mon Apr 18, 2011 8:38 am

chulett wrote:Probably better suited to the 'matches' function. ...

Hi chulette, Could you please explain more about 'matches' function.i dont have any idea about that.

madsongtel · Post by **madsongtel** » Tue Apr 19, 2011 3:53 am

Ravi.K wrote:Use Index Function

Thanks Ravi...Its working...