SeanHoppe.com > Cleo Best Practices > SQL Select of EXDGDPP for Numeric Field Decimal Values

Querying EXDGDPP for Numeric Field Decimal Values


When performing a Physical/Logical Table refresh in Cleo (EXTOL) EDI Integrator, end-users will want to take into account manually entered decimal values.

In our example below we performed the SQL query over EXDGDPP to determine the decimal positions of JDEdwards F47012 numeric fields.

Cleo Extol EDI Integrator Table EXDGDPP of JDEdwards F47012 Numeric Values
SQL Query: SELECT * FROM EXDGDPP WHERE GDFLDC>0 AND GDRCFM ='F47012' AND GDGFIL = 'I850JDE3'

Note: Field GDFLDC will show the respective decimal position.






By: on
EXTOL Business Partner Logo

More CLEO Examples

We have over 300+ examples of how Cleo EDI Integrator (EEI) can be customized to meet your organization's needs

Each of our examples are free to review and use.

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