Hi All,
 
I am unable to set the Session to Latin.
I am using TD 14 & trying to logon from Unix terminal using below command:
bteq -c Latin1 .logon server/user,pwd
(Note: i am able to set the same for Acii which is default or utf8 using "bteq -c Ascii" or "bteq -c utf8)
 
I referred below links

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,'|||')