JDE Enterprise Unicode

120 pts.
Tags:
Avantis
iSeries
JDE
JDE E1 9.0
Unicode
We are upgrading from JDE A7.30 co-existance to Enterprise One. The database has been converted to Unicode. I have another application (Avantis) which integrates to DDM files on a second iSeries which does not use Unicode. How can I access/create these DDM files to appear non-unicode to the second iSeries?
ASKED: February 10, 2010  4:17 PM
UPDATED: March 18, 2011  1:31 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

There shouldn’t be any problem with the files between the two systems — assuming the systems are configured appropriatly. For example, if you’re going to be storing and retrieving Unicode data in SQL tables (DB2 physical files) and especially if you’re expecting networking protocols such as DDM/DRDA to transfer data between multiple systems, you will want system attributes such as QCCSID to be set appropriately.

I don’t know a good reason for an improper QCCSID value, but I know that it’s common. If one or both of your systems is set to 65535, for example, you will want to keep specific control over individual jobs and/or profiles. The system will try to follow your instructions — 65535 is somewhat like instructing the system <i>not</i> to perform conversions during transfers.

You might issue CHGJOB CCSID( 37 ) on the source system before connecting to the remote Unicode system. (Assuming 37 is appropriate for you.) A remote query should then present the Unicode data in a readable fashion within that job.

It’s usually far easier simply to set the systems appropriately than to try to keep up with every connection.

We have Unicode data in a number of our files and have no problem with accesses from other systems in our network.

If you have specific problems, post the source and target environments, the data descriptions, the access methods and the results. Suggestions are probably available.

Tom

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JDE9
    Does Unicode in JDE 9.0 support - Formscape?
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following