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.
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: Sean Hoppe on