SQL0440 - Routine XXXX in *N not found with specified parameters.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sanjay - 08 Jul 2006 15:35 GMT

Hi,
I have created a Stored Procedure in DB2/400 . This stored procedure is
receviing 2 numeric and 4 character variables in *ENTRY of my SP
program named XXXX written in RPG/ILE. Then Create procedure was
executed to make this program XXXX as SP.

When I am calling this SP from Front End (ASP web page), I am getting
the following error message.

"SQL0440 - Routine SPCRTNP in *N not found with specified parameters."

Any idea what the problem can be..

Thanks..
Sanj

Reply to this Message

jefftyzzer - 12 Jul 2006 06:48 GMT

Hi, Sanjay:

I'm working in the LUW world, but assuming things work the same on the
400, i.e., special registers are the same, have you:

1. tried the call by fully qualifying the SP, e.g., CALL SCHEMA.XXXX()?
2. set/checked the CURRENT PATH special register (the one that tells
DB2 where to look to resolve any unqualified SP and function
references) to make sure that your SPs home (schema) is listed?

Regards,

--Jeff

> Hi,
> I have created a Stored Procedure in DB2/400 . This stored procedure is
[quoted text clipped - 11 lines]
> Thanks..
> Sanj

Reply to this Message