Soundex function in 7.5 server vs 8.7 Parallel

kiranh_1214 · Post by **kiranh_1214** » Thu Jan 22, 2015 8:48 am

Team,

we are using a SoundexName function in datastage 7.5 server on windows. for a given string it is generating a value.

what is the equivalent of the SoundexName in datastage parallel 8.7?

Tried with Soundex function which is giving a another value for the same string in 8.7 Parallel.

Please let me know the equivalent value for the function SoundexName in 8.7 parallel edition on linux.

chulett · Post by **chulett** » Thu Jan 22, 2015 9:11 am

As far as I know, you'll either need to write your own or continue to use the Server routine in your Parallel jobs via a Server Shared Container.

qt_ky · Post by **qt_ky** » Thu Jan 22, 2015 12:30 pm

The 7.5 docs are getting scarce. I am wondering if the SoundexName function is home-grown, unique to your shop, or if it was built in. There are no matching search results on the ibm.com site.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 22, 2015 3:46 pm

SoundexName is/was NOT a built-in function. In any version.

A number of sites created similar routines. For example, I once created a Soundex algorithm for Pacific Island names (in which the rules around vowel handling, leading "NG", etc., are different than in US English). I called this SoundexPI. I suspect something similar has happened in your SoundexName function - whose source code you should be able to examine.

The Soundex algorithm is documented in many places on the web.
If you're going to create your own function you may prefer something like NYSIIS algorithm, which is more accurate.