Function Like and Soundex
Moderators: chulett, rschirm, roy
Function Like and Soundex
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
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
Consultant in DTS
Re: Function Like and Soundex
index function in transformer stage.Javieregh wrote:Eg:- table.column like '%XXXX%'
Or
Filter stage supports Like
Re: Function Like and Soundex
index(table.column,'XXX',0) Is this syntax ???
Thanks
Thanks
Consultant in DTS
Re: Function Like and Soundex
index(table.column,'XXX',1)Javieregh wrote:index(table.column,'XXX',0) Is this syntax ???
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: