All Forums Extensibility
TD_DEV245 20 posts Joined 08/12
27 Sep 2012
otranslate UDF returns nulls when hexadecimal values are used

Hi,
 I am using OTRANSLATE UDF to remove control characters.I am using it in the following format
OTRANSLATE(COLUMNNAME,'09'XC'0D'XC'20'XC,'|||')
I am trying to replace Tab,Carriage return and space with pipe symbol.It seems to work fine in my SQL assistant ,but when i test it on production data using another SQL Assistant null values are returned.I am sure that this column has data,still it is returning null values.
The session characterset is ASCII in both cases. 
The column is declared as LATIN characterset in DDL.
Does this cause the UDF to return NULL values?
Should I use Translate function in Teradata to change the characterset
Please reply its quite urgent
 
Thanks,
Vijayshankar

''Human race acts as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about''-Albert Einstein
You must sign in to leave a comment.