SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 Performing JDE SQL Select Statement from EXTOL Business Integrator (EBI)

Performing JDE SQL Select Statement from EXTOL Business Integrator (EBI)

3rd October 2014

In EXTOL Business Integrator there are many different ways of performing a specific task. Most of the times, there is no right or wrong way, but one might take longer than the other.

In our example below, we show how to set-up a SQL Select statement with TRIM(). Without TRIM() we need to pad the input parameter with blanks.

SELECT wwan8 from “CRPDTA”.“F0111” where TRIM(WWMLNM) = TRIM(${WWMLNM})

JDEdwards SQL Select statement with TRIM in EXTOL Business Integrator EBI

More information on JDE Best Practices and How-To’s


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 ' '; ?>