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

[Sanjay]

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

[jefftyzzer]

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

Sanjay wrote:

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