Peter,
One quick way to view the data is to be sure your green screen interactive job has a valid CCSID other than 65535. Try doing a CHGJOB CCSID(37) before running interactive SQL or DFU. That may resolve the corrupted display of the unicode data.
Mark
Mark Larson | Sr. Architect | ERP LX Architecture | Infor | Office: 312-474-7501 | mark.larson@xxxxxxxxx
-----Original Message-----
From: bpcs-l-bounces+mark.larson=infor.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+mark.larson=infor.com@xxxxxxxxxxxx] On Behalf Of Peter Heeren
Sent: Wednesday, September 09, 2009 9:44 AM
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
