6706: The string contains an untranslatable character

General

6706: The string contains an untranslatable character

SELECT

                 '@#$' || TRIM(CAST((COALESCE(VARA,'')) AS VARCHAR(30))   )       || '|' ||

                 TRIM(CAST((COALESCE('"' || RTRIM(SUBSTR(VARB,1,254))    || '"' ,'')) AS VARCHAR(300))   )           || '|' 

FROM  DB.TABLE;   

Can someone please help for solution?

Thanks,

Shankar

1 REPLY
Supporter

Re: 6706: The string contains an untranslatable character

Hi,

Please share sample data of "DB.TABLE".

Thanks,

Rohan Sawant