RPG (IBM i / AS/400) · DB2 SQLCODE

SQLCODE -440 - No Routine Found With Matching Signature

What does SQLCODE -440 - No Routine Found With Matching Signature mean in RPG (IBM i / AS/400)?

A CALL statement, or a scalar/table function reference in the SQLRPGLE program, specified a name and parameter list that doesn't match any overload registered for that routine in the schema.

SQLCODE -440 - No Routine Found With Matching SignatureDB2 for i · SQLRPGLE

Condition

A CALL statement, or a scalar/table function reference in the SQLRPGLE program, specified a name and parameter list that doesn't match any overload registered for that routine in the schema.

Fix

Check the number, order, and data types of the arguments in the CALL statement against the routine's CREATE PROCEDURE/FUNCTION definition, and confirm the right schema is in the library list when more than one routine shares that name.

Related db2 sqlcode