SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 EBI and Migrating to JDE E1 B9 on the iSeries

EBI and Migrating to JDE E1 B9 on the iSeries

22nd January 2015

When upgrading to 9.0 JD Edwards, the unicode tables have CCSID = 13488. Users will probably see their existing (OneWorld) JDE tables using CCSID = 37.

This change occurs because JDE B9 by default installs where UNICODE = TRUE.

I performed a test with EBI 2.6 and EXTOL Business Integrator was able to read/write to the CCSID: 13488 fields.

JDE BACKGROUND:

JD Edwards EnterpriseOne B9 Applications Installation Guide

1.6.2.1 Unicode

Unicode specifies that the data stored in the data source is in Unicode format. For installs, all data sources default to Unicode.

For DB2\400, the code page is stored at the table level. Therefore, the Unicode attribute must be consistent within a data source (that is, within a library).

Note that the code page still must be set to the correct value even though the data sources may all be Unicode. The Unicode flag only indicates what column type is used to store character data in a Unicode database. For example, for DB2\400, it indicates GRAPHIC\VARGRAPHIC with CCSID 13488 is used. Refer to the following section for the code page settings.


By: on
load('http://www.seanhoppe.com/EXTOL-Blog-Feed2/'); $feed2 = array(); foreach ($rss2->getElementsByTagName('item') as $node2) { $item2 = array ( 'title' => $node2->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node2->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node2->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node2->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed2, $item2); } $limit2 = 5; $rss3 = new DOMDocument(); $rss3->load('http://www.ebithree.com/EBIThree-RSS/'); $feed3 = array(); foreach ($rss3->getElementsByTagName('item') as $node3) { $item3 = array ( 'title' => $node3->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node3->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed3, $item3); } $limit3 = 5; $rss4 = new DOMDocument(); //$rss4->load('http://www.ebithree.com/EBIThree-RSS/'); $rss4->load('http://www.ebiworld.com/EBI-Feed/'); $feed4 = array(); foreach ($rss4->getElementsByTagName('item') as $node4) { $item4 = array ( 'title' => $node4->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node4->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed4, $item4); } $limit4 = 5; echo ' '; ?>