Re: Systables - table LABEL not readable

Hmmm! I hope this is not a reply to my post - I really hope I did not suggest changing QCCSID to 65535.

So again, ++++++1 on what you said about changing the system value QCCSID to something other than 65535.

Hey, it's Friday, I could have said anything, right?

Cheers
Vern

On 1/12/2018 12:28 PM, Rob Berendt wrote:

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)
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

for

that


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
-- 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