var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problem in DB2V5.1 Stored Procedure invocation
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
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?