× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



+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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.