Hi,

We have a DB2 V5.1 stored procedure. We registered it thru a insert into SYSIBM.SYSPROCEDURES and then started the SP.

When trying to execute,we are getting sqlcode -204
-204 name IS AN UNDEFINED NAME

If the specified object is a stored procedure, add a row to the
SYSIBM.SYSPROCEDURES catalog table to define the stored procedure. Issue
the -START PROCEDURE command to activate the new definition.

We did a -STA PROC() also.

Could any pls help us out in this as it has been a showstopper for us.
Any suggestion will be highly appreciated

Thanks

I'm assuming this is DB2 V5.1 on OS/390, but you don't say. Have you verified the procedure name is indeed in the SYSPROCEDURES table?