Function Like and Soundex

Javieregh · Post by **Javieregh** » Fri Sep 17, 2010 5:10 am

Hi All,

I need any functions or suggestions to implement the LIKE and SOUNDEX operator in datastage.

Eg:- table.column like '%XXXX%'

and also the function

Eg. Upercase(Soundex(Trim Leading Trailing(table.column)))

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,
Xavi

HariK · Post by **HariK** » Fri Sep 17, 2010 5:25 am

Javieregh wrote:Eg:- table.column like '%XXXX%'

index function in transformer stage.
Or
Filter stage supports Like

Javieregh · Post by **Javieregh** » Fri Sep 17, 2010 5:28 am

index(table.column,'XXX',0) Is this syntax ???

Thanks

HariK · Post by **HariK** » Fri Sep 17, 2010 5:33 am

Javieregh wrote:index(table.column,'XXX',0) Is this syntax ???

Thanks

index(table.column,'XXX',1)

Javieregh · Post by **Javieregh** » Fri Sep 17, 2010 5:41 am

and Soundex function ??

HariK · Post by **HariK** » Fri Sep 17, 2010 5:50 am

Javieregh wrote:and Soundex function ??

There is soundex function, but it does not behave same as the SQL funtion. search Soundex on help available on Datastage Designer

ray.wurlod · Post by **ray.wurlod** » Fri Sep 17, 2010 6:13 am

HariK wrote:... but it does not behave same as the SQL funtion...

Are you sure?

chulett · Post by **chulett** » Fri Sep 17, 2010 6:43 am

Soundex is Soundex and really should behave identically across platforms. Have you found that not to be the case?

HariK · Post by **HariK** » Mon Sep 20, 2010 12:47 am

chulett wrote:Soundex is Soundex and really should behave identically across platforms. Have you found that not to be the case? :?

My Bad. The function is based on the standard, open algorithm for SOUNDEX evaluation

DSXchange

Function Like and Soundex

Function Like and Soundex

Re: Function Like and Soundex

Re: Function Like and Soundex

Re: Function Like and Soundex