Hello @all,
i have a problem....i wrote a stored procedure which ends with the command "complete successfully", but when i will call the stored procedure i got the message:
SQL0444N Routine "xxx" (specific name "xxx") is implemented
with code in library or path "\xxx", function "xxx" which cannot be
accessed. Reason code: "6". SQLSTATE=42724.
I read a lot about that, but i can't find the error...can anybody help me???
The stored procedure looks like:
Create PROCEDURE XXX (IN name CHAR(10))
SPECIFIC XXX
DYNAMIC RESULT SETS 1
DETERMINISTIC
LANGUAGE C
PARAMETER STYLE GENERAL
NO DBINFO
FENCED
THREADSAFE
READS SQL DATA
PROGRAM TYPE MAIN
EXTERNAL NAME xxx!XXX
;
i have a problem....i wrote a stored procedure which ends with the command "complete successfully", but when i will call the stored procedure i got the message:
SQL0444N Routine "xxx" (specific name "xxx") is implemented
with code in library or path "\xxx", function "xxx" which cannot be
accessed. Reason code: "6". SQLSTATE=42724.
I read a lot about that, but i can't find the error...can anybody help me???
The stored procedure looks like:
Create PROCEDURE XXX (IN name CHAR(10))
SPECIFIC XXX
DYNAMIC RESULT SETS 1
DETERMINISTIC
LANGUAGE C
PARAMETER STYLE GENERAL
NO DBINFO
FENCED
THREADSAFE
READS SQL DATA
PROGRAM TYPE MAIN
EXTERNAL NAME xxx!XXX
;