Re: ERPLX 8.3.3 - Unreadable characters in some files because of TYPE GRAPHIC - CCSID 13488

mark, sean,

I already changed sysval QCCSID(37). The jobs now run with CCSID(37).
Via SQL I can view, insert and update the data in a readable way.

Only DFU is giving me problems. I can not view, insert or update data from
there.
When I enter a record via DFU into ZCC and try to read the data via SQL
all the records are readeable except the one entered via DFU

regards,

Peter






Mark Larson <Mark.Larson@xxxxxxxxx>
Sent by: bpcs-l-bounces+pheeren=thetford.eu@xxxxxxxxxxxx
09/09/2009 18:28
Please respond to
BPCS ERP System <bpcs-l@xxxxxxxxxxxx>


To
BPCS ERP System <bpcs-l@xxxxxxxxxxxx>
cc

Subject
Re: [BPCS-L] ERPLX 8.3.3 - Unreadable characters in some files
because of TYPE GRAPHIC - CCSID 13488






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