SQuirreL SQL Client

Email Archive: squirrel-sql-users (read-only)

[Squirrel-sql-users] iSeries data and CCSID

From: Robert Rogerson <rogersonra@gm...> - 2011-02-28 21:20

HI all,

How do I change the CCSID for data returned from an SQL statement where the
db is on an iSeries.

Thanks,

Rob

Thread View

Thread	Author	Date
[Squirrel-sql-users] iSeries data and CCSID	Robert Rogerson <rogersonra@gm...>

Re: [Squirrel-sql-users] iSeries data and CCSID

From: Lennon , Sam <slennon@pi...> - 2011-03-01 17:40

Attachments: Message as HTML

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