Extracting Data from JDE 9.0 to Ascii

Our company is upgrading their JDE XE to 9.0. JDE XE is an ASCII database and JDE 9.0 is Unicode. There are a lot of downstream apps and databases that depends upon JDE as a data feed. As you all know, the downstream apps needs to be upgraded to Unicode, otherwise they face a potential data loss due to Unicode to Ascii translation. Anyone have suggestions to how we can buy time while we upgrade these apps

If you are not doing languages other than English, then it isn't a hard rule that you have to have your Business Data in Unicode. Just make sure your CNC implementation person is aware of this requirement, and to make sure they switch off the Unicode flag for the affected data sources.

If/when you are ready, you can do a Unicode conversion afterwards.

Right now, the business data is all English. However, the reason why the company went Unicode is because there may be some Asian data in the near future. Are you saying there is a flag that you can set in JDE that will run ASCII until a later time then switch the flag over when we have Asian data?

Yes, there is a Unicode flag that you can toggle for a data source's configuration in P98611 (or one of its row exits).

Be aware, all tables in the data source must be set the same way. When you upgrade the data, your installation person should know to set the data sources the right way.

You don't mention the database platform you are using. This is a consideration, because in SQL Server, Business Data and Control Tables live in a single database, and should be set together. If it's one of the others, you could possibly set Business Data as non-Unicode and leave Control Tables as Unicode, if your 3rd party programs don't touch them.

Later on, hopefully the timing works out right, and your 3rd party programs are upgraded before you need the Asian languages active. At some point, you will run the Unicode conversion procedure, and afterwards flip the switch on the Unicode flag.