Lee wrote:
Karl, you are right - the CCSIDs are different. For the tables that
come back as text the CCSID is 37, for the others it is 65535. I do
not expect to be able to modify these on the source systems, so a
colleague told me about a setting in the Client Access ODBC setup for
my desktop to change - I am testing that next. However, does anyone
know if (and how) you can configure the DB2Connnect connection on the
AIX server to do the same thing (convert binary to text)?
Don't know of a config option, but a suggested workaround is to use a
cast on the client side:
select cast(GBCO as char(5) ccsid 37), count(*)
from library.F0902 group by GBCO
--
Karl Hanson