When reading the data using SQL, can you CAST the data to a different
CCSID ?
The issue may be that iSeries Access for Windows cannot display unicode
data (13488) so this must be converted to a different CCSID (if
possible) to display within iSeries Access for Windows.
-----Original Message-----
From: bpcs-l-bounces+sean.mcgovern=covidien.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+sean.mcgovern=covidien.com@xxxxxxxxxxxx] On
Behalf Of Peter Heeren
Sent: 09 September 2009 15:44
To: BPCS ERP System
Subject: [BPCS-L] ERPLX 8.3.3 - Unreadable characters in some files
because of TYPE GRAPHIC - CCSID 13488
Hello,
We have installed ERPLX 8.3.3 LX for testing.
Some field types are changed to Type GRAPHIC, with CCSID code 13488. For
example in the general code file ZCC.
The data in the ERPLX applications is maintainable (SYS105)
SQL queries resulted in unreadable characters. This was solved by
changing
our system value QCCSID from 65535 to 37
(I am able to do this because we run this test environment on a
dedicated
partition)
When I try to use DFU (UPDDTA) to retrieve and update the data in the
file, I receive error messages "The retrieved record contains invalid
data."
Also when I insert new data it is unreadable when I try to retrieve it
via
SQL or RUNQRY.
It must be an OS400 setup issue in combination with these ERPLX files
Have anyone encountered these kind of problems before since version
8.3.x
?
Best regards,
Peter Heeren
Please note: This e-mail / fax is confidential and may also be
privileged.
Please notify us immediately if you are not the intended recipient. You
should not copy it, forward it or use it for any purpose or disclose the
contents to any person.
For details of our international offices please visit our website:
http://www.thetford.eu
Thetford B.V. is statutorily based in Etten-Leur, Netherlands. Chamber
of
Commerce West-Brabant registration number 20037470.
PBefore printing, think about the environment
midrange.com
