Hi,
I am trying to execute an DB2 SQL stored proc in mainframe.
my proc is
CREATE PROCEDURE db2t.abuproc
()
LANGUAGE SQL
external name abuproc
wlm environment dbatspas
BEGIN
UPDATE DBXR.PRTTAB SET NUMBER=10 WHERE NUMBER=0;
end?
But when am executing it thru coammnd line editor, am gtting SQLERROR -444...
it sauys its not able to locate the package...is it required to use a package for a SQL Stored proc and if so pls let me know where is the package is creatied by the system...
appreciate a help.
thanks
appunni