› › Number of Parameters Does Not Match

Number of Parameters Does Not Match in SQL Action Select Statement


Scenario:

VAI S2K user is attempting to query PO Header file (VEDXPOHW), via EBI SQL Action.

EXTOL Business Integrator 2 VAI S2K SQL Select Statement for VEDXPOHW

Issue:

While attempting to query DB2 table: VEDXPOHW we encounter an error: Number Parameters Does Not Match

EXTOL Business Integrator 2 EBI SQL Select Statement Error Number Parameters Does Not Match

Resolution:

During the set-up of the SQL action, the SQL Procedure dialog checkbox was checked. By unclicking the box, the SQL action worked.



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.