MCH1202: Data Decimal Error When Calling Stored Procedure

Problem

A MCH1202: Data Decimal Error is thrown to the QZDASOINIT joblog after calling a stored procedure from an application.

A TRCCNN communications trace shows the parameters being correctly passed on the execution of the CALL SQL statement. Typically, when a MCH1202 is thrown when calling a stored procedure, it implies the procedure and/or parameter definition are missing or incorrect.

You can check to determine if the stored procedure lies within the system catalog information by issuing the following queries through iSQL or Run SQL Scripts.

SELECT * FROM QSYS2/SYSPARMS WHERE SPECSCHEMA='SCHEMA_NAME' AND SPECNAME='PROCEDURE_NAME'
SELECT * FROM QSYS2/SYSROUTINE WHERE SPECSCHEMA='SCHEMA_NAME' AND SPECNAME='PROCEDURE_NAME'

where SCHEMA_NAME is the library the stored procedure resides and PROCEDURE_NAME is the stored procedure name.



Resolution

If the stored procedure is not found in the result set of one or both of the select statements, have the client re-run the CREATE PROCEDURE SQL statement to re-populate the system catalog tables QSYS2/SYSPARMS and QSYS2/SYSROUTINE.