120 pts.
 JDE Enterprise 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?

Software/Hardware used:
ASKED: February 10, 2010  4:17 PM
UPDATED: March 18, 2011  1:31 PM

Answer Wiki:
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
Last Wiki Answer Submitted:  February 10, 2010  9:50 pm  by  TomLiotta   110,115 pts.
All Answer Wiki Contributors:  TomLiotta   110,115 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Does Unicode in JDE 9.0 support – Formscape?

 10 pts.