RE: Impact of QCCSID change

Marty, 

Generally speaking the default is ok until you want to have DB2
communicate with other DB2 systems in that case you should use 37. But
there is no real need to change the global system value, rather just
change the individual values.

We do not intentionally use Unicode, but I believe you select the DBCS
for it in any case the ccsid is 37 because we talk to other db2 systems
using drda.

-----Original Message----- 
From: Urbanek, Marty [ mailto:Marty_Urbanek@xxxxxxxxxxxx
<mailto:Marty_Urbanek@xxxxxxxxxxxx> ] 
Sent: Wednesday, September 10, 2003 11:35 AM 
To: 'midrange-l@xxxxxxxxxxxx' 
Subject: Impact of QCCSID change 


Our QCCSID is set at 65535 because that was the default when I installed
OS/400 and I never had a reason to change it. We have also checked with
some of our US customers and they also run 65535. We know we have
customers outside the US who run other CCSIDs and we occassionally have
a support issue but no big deal.

We are now running into some complications storing unicode data in
DB2/400 databases (VARGRAPHIC + CCSID 13488), and it seems like some
things might be easier if QCCSID was non-hex, like perhaps 037. The
problem with 65535 is not so much accessing the data via JDBC, but
rather through native utilities like STRSQL screen.

I am leery of changing QCCSID because I don't know what else might
happen, i.e. would components of OS/400 start up under the new value and
misunderstand existing data in files, etc, bringing the system to its
knees and/or start converting things so it would then be impossible to
change back to 65535 if we needed to?

I am pretty ignorant of this whole subject because my OS/400 background
was mostly in communications, so to me 65535 always seemed like the
ideal. I didn't want the system changing any data as I did my I/O. If I
wrote a byte to disk, that was the exact byte I wanted recorded and the
exact byte I wanted to read back, regardless of where my comm program
was running. 

What do you all use for QCCSID, do you store any unicode data in DB2/400
and if so do you use GRAPHIC/VARGRAPHIC or FOR MIXED DATA or what?

All advice appreciated. 

THANKS, 
-Marty 


_______________________________________________ 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,

visit: http://lists.midrange.com/mailman/listinfo/midrange-l
<http://lists.midrange.com/mailman/listinfo/midrange-l>  
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/midrange-l
<http://archive.midrange.com/midrange-l> .