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