Problem with stored procedure

[fanch]

Hello !

I trying to create a DB2 Stored procedure in OS/390, I received an
authorization error message (-592) .

I don't want to use an WLM environment , but the DB2 addressing space.

I hope someone can help me, thank you.


CREATE PROCEDURE PROC2 (IN CDARGT_IN CHAR(30),
OUT NOROWS INT)
NO WLM ENVIRONMENT
LANGUAGE SQL
BEGIN
DECLARE CDARGT_OUT CHAR(30) ;
DECLARE AT_END INT DEFAULT 0 ;
DECLARE NOT_FOUND CONDITION FOR '02000' ;
DECLARE C1 CURSOR FOR SELECT CDARGT FROM MIGALT.TB3SERTB
WHERE CDARGT = CDARGT_IN;
DECLARE CONTINUE HANDLER FOR NOT_FOUND SET NOROWS=1 ;
OPEN C1 ;
FETCH C1 INTO CDARGT_OUT ;
CLOSE C1 ;
END&
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -592, ERROR: NOT AUTHORIZED TO CREATE FUNCTIONS OR
PROCEDURES IN WLM ENVIRONMENT NO WLM ENVIRONMENT
DSNT418I SQLSTATE = 42510 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXIVRO SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 150 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000096' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+---------+