SQL10007N 99999 on z/OS stored proc call

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • N61601@gmail.com

    SQL10007N 99999 on z/OS stored proc call

    I'm trying to call a very basic stored procedure from "Command Line
    Processor for DB2 Client 9.5.0" to "DB2 OS/390 8.1.5".

    The call statement-
    call DB2DB.STORPROC( )

    The result -
    CLI0125E Function sequence error.
    SQLSTATE=HY010
    SQL10007N Message "99999" could not be retrieved. Reason code: "4".

    The z/OS stored procedure
    CREATE PROCEDURE STORPROC()
    RESULT SETS 1
    EXTERNAL NAME STORPROC
    LANGUAGE SQL
    PARAMETER CCSID ASCII
    WLM ENVIRONMENT DB8WLM1
    BEGIN
    SET RECODE = 0 ;
    END
    !

    What's going on?

    Regards,
    Serenity
Working...