Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    13

    Unanswered: Problem in DB2V5.1 Stored Procedure invocation

    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
    Thanks
    Ranjith

  2. #2
    Join Date
    Feb 2004
    Posts
    25
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •