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
A free web counter provided by GoStats.