Sybase ASE Soundex Function Issue -Need Suggestion
Dear Team
I am using Sybase Adaptive Server Enterprise/15.7 (ASE). Trying my luck on SOUNDEX function to get unique records
Though the command works for characters and provides unique code for similar outputs.
But when i try with Starting numbers ( Followed with Street address ) , soundex does not work efficiently . Below examples show 0000 for 2 distinct address shown. Ideally it should show two different codes as both are distinct values .
Please guide if i am missing anything.
Code:
[
SELECT
Street_Lane,
soundex(Street_Lane) as Street_Lane_Code
FROM Cities_Table
where City = 'XYX
]
Output
Code:
[Street_Lane Street_Lane_Code
96 Queen lane; Main 200 0000
96 Queen lane; Main 200 0000
141 Mike Lane 0000
141 Mike Lane 0000
]
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by RudiC; 05-16-2017 at 12:04 PM..
Reason: Added CODE tags.
[FONT=Tahoma]
...
I am using Sybase Adaptive Server Enterprise/15.7 (ASE). Trying my luck on SOUNDEX function to get unique records
Though the command works for characters and provides unique code for similar outputs.
But when i try with Starting numbers ( Followed with Street address ) , soundex does not work efficiently . Below examples show 0000
for 2 distinct address shown. Ideally it should show two different codes as both are distinct values .
...
From the ASE documentation at: infocenter.sybase.com
Adaptive Server Enterprise 15.5
> Transact-SQL User's Guide
> Using the Built-In Functions in Queries
> String functions used for character strings or expressions
> Examples of using string functions
Code:
The soundex function converts a character string to a four-digit code for use in a comparison.
It ignores vowels in the comparison.
Nonalphabetic characters terminate the soundex evaluation.
This function always returns some value.
There's no additional information regarding soundex function in higher ASE versions.
So looks like you are out of luck here.
The soundex implementation in Sybase apparently works only on strings that contain characters from the alphabet; not on strings that contain numbers/digits.
Last edited by durden_tyler; 05-16-2017 at 08:30 PM..
This User Gave Thanks to durden_tyler For This Post:
Dear Team
Please provide suggestion on below query which is used in Sybase Adaptive Server Enterprise/15.7 (ASE).
Query takes more time > 30 Mins to 1 Hr
All required indexes are built
Can we have any efficient approach to get the data retrieval faster for below query.Any help... (0 Replies)
Hi Team ,
I am new to Sybase Adaptive Server Enterprise/15.7 (ASE) and need some guidance to find the different values in serial format column.
SELECT DISTINCT SERIAL_FORMAT FROM PRODUCTS
It has values with below format which contains 12 digits hexadecimal characters with... (2 Replies)
Hi Team -
I am using Sybase ASE 15.7 version. Below query is throwing an error
stating Error : incorrect syntax near the keyword 'OVER'
SELECT
EMPLOYEE_ID ,
EMPLOYEE ,
Department,
CAST( Salary as DECIMAL( 10, 2 ) ) AS Salary
CAST(AVG( Salary) OVER ( PARTITION... (3 Replies)
HI Team
I am using Sybase ASE15.7 version.
Below is the sample column values .
http://abc.lifeline.airs.com/support/
https://xyzbre.lifeline.airs.com/video/
Would like to know how to
Trim http:// and https:// from above list of example
Remove characters after first /
Include only the... (3 Replies)
i'm looking for an installer of Sybase ASE 11.9.2.6 for HP-UX. tried buying from the local distributor but he can only give me the latest version. can anyone point me to where i could possibly get it? (0 Replies)
hi,
I am trying to load a sybase table using a file ( unit separator is the delimiter) which is in IQ server.
I Used load statment as below
execute ('LOAD TABLE schemaname.tablename (' || ' name, age, date, Symbols) from ' || ' '' /filepath/file.txt '' ' || ' QUOTES off ' || ' DELIMITED... (0 Replies)
This is my code
***************
#!/bin/bash
echo -e "no: \c"
read no
case $no in
1)fun;;
*)echo "wrong";;
esac
fun()
{
echo "in"
}
this is my output error
***************** (2 Replies)
To begin:
I use Linux
The Problem:
I need bcp functionality for scripts. Perl modules, such as Sybase:xfer, require ctlib which comes with Sybase Open Client. Talking with Sybase sales
reps is an exercise in futility and hate. They know absolutely nothing about their own products and will... (0 Replies)
05-16-2017
