Re: CCSID 65535 and SQL

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

There's a built-in option to convert in Run SQL Scripts.  In your JDBC
Configuration, it's on the Translation tab.

HTH


date: Tue, 6 Dec 2022 16:42:25 -0500
> from: Bobby Adams <bobby_adams@xxxxxxx>
> subject: CCSID 65535 and SQL
>
> Hi All,
>
> There is a vendor file that has a field with CCSID 65535 assigned.? Can
> SQL convert that field to CCSID 1208?? I am asking about SQL because the
> person who will be working with the file prefers SQL.
>
> When we try to CAST it to 1208 we get '[SQL0332] Character conversion
> between CCSID 65535 and CCSID 1208 not valid.'
>
> Thanks in advance.
>
> Regards,
>
> Bobby