Page 1 of 1
Function Like and Soundex
Posted: Fri Sep 17, 2010 5:10 am
by Javieregh
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
Re: Function Like and Soundex
Posted: Fri Sep 17, 2010 5:25 am
by HariK
Javieregh wrote:Eg:- table.column like '%XXXX%'
index function in transformer stage.
Or
Filter stage supports Like
Re: Function Like and Soundex
Posted: Fri Sep 17, 2010 5:28 am
by Javieregh
index(table.column,'XXX',0) Is this syntax ???
Thanks
Re: Function Like and Soundex
Posted: Fri Sep 17, 2010 5:33 am
by HariK
Javieregh wrote:index(table.column,'XXX',0) Is this syntax ???
Thanks
index(table.column,'XXX',1)
Posted: Fri Sep 17, 2010 5:41 am
by Javieregh
and Soundex function ??
Posted: Fri Sep 17, 2010 5:50 am
by HariK
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
Posted: Fri Sep 17, 2010 6:13 am
by ray.wurlod
HariK wrote:... but it does not behave same as the SQL funtion...
Are you sure?
Posted: Fri Sep 17, 2010 6:43 am
by chulett
Soundex is Soundex and really should behave identically across platforms. Have you found that not to be the case?
![Confused :?](./images/smilies/icon_confused.gif)
Posted: Mon Sep 20, 2010 12:47 am
by HariK
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