Thanks Rob...I'll look into these sources.
Steve Needles
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, July 09, 2013 2:53 PM
To: Midrange Systems Technical Discussion
Subject: RE: RESOLVED: SQL-inconsistent results using XMLELEMENT, XMLSERIALIZE, XMLCONCAT
I miss the old days of just ASCII vs EBCDIC. Where if you knew the hex code of the data you knew what the heck it was. Now it's the hex code of the data plus what the column, table or file's coded character set id is.
Oh well, that genie isn't going back into the box. IBM has some
redbook(s) on globalization and whatnot you can look at.
You can try following the language id specified on SET OPTION
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzsoption.htm
You may want to read the link right there for globalization as my perspective is English should be good enough for everyone and I wouldn't want you to bury this in your code only to find out you've just shot yourself in the foot.
But, again, somewhere on your system you have the default at 65535.
CHGSYSVAL QCCSID is something many of us have ran midday with no ill effects. Oh, somewhere is a Chuck Pence caveat on why that is evil, but I'll leave the manual labor of looking that up to you.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: "Needles,Stephen J" <SNEEDLES@xxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>,
Date: 07/09/2013 02:55 PM
Subject: RE: RESOLVED: SQL-inconsistent results using XMLELEMENT,
XMLSERIALIZE, XMLCONCAT
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Is there a column or book or paper somewhere that can take the mystique
out of the CCSID stuff? While I can generally figure out what IBM's
documentation is telling me, this time it is only confusing me.
Steve Needles
________________________________
This communication, including attachments, is confidential, may be subject
to legal privileges, and is intended for the sole use of the addressee.
Any use, duplication, disclosure or dissemination of this communication,
other than by the addressee, is prohibited. If you have received this
communication in error, please notify the sender immediately and delete or
destroy this communication and all copies.
TRVDiscDefault::1201
midrange.com
