EBIworld.com > EBI/Clarify Tips > Calling SQL procedures from EXTOL Business Integrator

Calling SQL procedures from EXTOL Business Integrator

TAGS: EXTOL Business Integrator / EXTOL EBI / SQL / iSeries /

Occasionally we need to execute a non-EBI procedure within EXTOL Business Integrator. With EBI we can call a SQL Procedure from a ruleset or within a Business Process Script (version 2.4 or later)

In the example below we will review how to set-up an iSeries SQL Procedure and call it from an EBI Business Process Script.

iSeries Set-up

Using STRSQL, we will execute the freeform statement. For a breakdown of the statement below, CLICK HERE.

SQL Procedure Freeform statement

Once the statement above has been created. It can be viewed in QSYS2/SYSROUTINE.

Click here for the EBI Action Set-up

Copyright 2012 @ www.seanhoppe.com


By: on
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.