This may not answer your question, but it may help with background. And I have not done a lot with it.
The table you are reading is tagged with a CCSID (37, for example, is USA English.) However, there is also 65535, which is hex and is not translated. (Strictly speaking, individual columns can also be tagged with a CCSID on more recent OS versions.)
There is also a CCSID associated with the servicing job on the iSeries.
Some systems have a default of 65535 for both files and jobs.
The "DB2 for i SQL Reference" http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/index.jsp?topic=/rzahg/icmain.htm has lots more info on CCSIDs. It can be pretty convoluted.
Sam
________________________________
From: Robert Rogerson [mailto:rogersonra@...]
Sent: Monday, February 28, 2011 4:21 PM
To: squirrel-sql-users@...
Subject: [Squirrel-sql-users] iSeries data and CCSID
HI all,
How do I change the CCSID for data returned from an SQL statement where the db is on an iSeries.
Thanks,
Rob
|