-469   SQL CALL STATEMENT MUST SPECIFY AN OUTPUT HOST VARIABLE FOR PARAMETER number

Explanation

DB2® received an SQL CALL statement for a stored procedure. DB2 found the row in the SYSIBM.SYSROUTINES catalog table associated with the requested procedure name. However, parameter number was identified in the SYSIBM.SYSPARMS table as an OUT or INOUT parameter. A host variable must be supplied on the SQL CALL statement for a parameter that is defined as OUT or INOUT.

number
The parameter number from the ORDINAL field in SYSIBM.SYSPARMS.

System action

The statement cannot be processed.

Programmer response

If the SQL CALL statement is coded incorrectly, modify the SQL application to provide an output host variable on the SQL CALL statement.

If the SYSIBM.SYSPARMS table contains incorrect information, the DROP PROCEDURE and CREATE PROCEDURE statements must be used to replace the catalog definition for the stored procedure.

SQLSTATE

42886