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

A free web counter provided by GoStats.