|
In the spirit of America's forefathers one could be asking "why not"
instead of why.
In other words, if you had been running at QCCSID = 37 for some time now
is there any reason why you would change to 65535?
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/ddp/rbal1apendixqccsid.htm
<snip>
IBM i system value QCCSID
The default system value for QCCSID (coded character set identifier) is
65535.
Data tagged with this CCSID is not to be converted by the receiving
system. You might not be able to connect to an unlike system when your
IBM® i application requester (AR) is using this CCSID. Also, you might not
be able to use source files that are tagged with this CCSID to create
applications on unlike system
</snip>
The system actually goes through a long hierarchy doing it's darndest to
avoid using that 65535
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/nls/rbagsjobdefaultccsid.htm
So, for the love of God, change the darn thing!
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: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> Date: 01/12/2018 01:08 PM Subject: Re: Systables - table LABEL not readable Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> +1 You can also cast the field as CHAR with a CCSID, but it's recommended to make the system value change Rob cites. DSPFFD on SYSTABLES says that LABEL is a GRAPHIC type, which isn't just DBCS anymore - and the CCSID is 1200 - the spaces you see between letters are almost always hex zeroes. Regards Vern On 1/12/2018 7:36 AM, Rob Berendt wrote:We run with QCCSID set to 37.Ë
Watch this.
CHGJOB CCSID(65535)
STRSQL
select label
from systables
à / È / À Ñ Ä È Ñ ? > / Ê ` < Ñ Ë È Ã Ñ Á % À Ë Â ` % Ñ /
CHGJOB CCSID(37)for
STRSQL
select label
from systables
Data dictionary: List fields by Alias
Strongly recommend
WRKSYSVAL QCCSID and just change that to 37.
Many of us have, and midday on production machines.
Chuck Pence had a concern with that but you'll have to search archives
that-- 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: https://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l. Please contact support@xxxxxxxxxxxx for any subscription related questions. Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD
Rob Berendt
-- 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: https://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l. Please contact support@xxxxxxxxxxxx for any subscription related questions. Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.