DSXchange

Posted: **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.

Posted: **Sun Apr 17, 2011 10:24 am**

Use Index Function

Posted: **Sun Apr 17, 2011 10:29 am**

Probably better suited to the 'matches' function.

Posted: **Mon Apr 18, 2011 12:52 am**

we can do it in filter stage as well

Posted: **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.

Posted: **Tue Apr 19, 2011 3:53 am**

Ravi.K wrote:Use Index Function

Thanks Ravi...Its working...

DSXchange

Like operator convertion in DataStage

Like operator convertion in DataStage