Hello,
i wrote a stored procedure, which ends with the command:
DB20000I The SQL command completed successfully.
But when i call the stored procedure i got the following error:
SQL0444N Routine "DB" (specific name "DB") is implemented
with code in library or path "\test", function "DB" which cannot be accessed. Reason code: "4". SQLSTATE=42724
...
Loop123
Last Activity: Jan 30 '07, 06:57 AM
Joined: Dec 16 '06
Location:
-
Stored Procedure!! SQL0444n Reason 4!!Is this normal.....
-
SQL0444N Code 6 when calling STORED PROCEDURE
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.
... -
Stored Procedure with db2cfg Api to get the cfg of a database!!
Hello,
i want to write a Stored Procedure in order to get the configuration parameters of a database like in the command line "db2 get db cfg for database"...i tried the following code:
I used the Api, but when i tried this code the error SQL0444N with reason 6 comes or it doesn't work...have anyone an idea???
Thanks
/**APIs USED :
** INSTANCE ATTACH sqleatin()...
No activity results to display