Hi,
After creating the stored procedure, have you compiled the stored procedure?
Here are the steps in case you have not -
1. Write the code in Notepad & save it with the extension as .db2.
(make sure you DB2 is connected)
2. On command line editor give command tf-! vf- <path for your file>
(here ! is the terminating character in your stored procedure)
This will give you a message that the check completed & then you can run the procedure from command line editor with a call command.
Hope this helps you.
Regards,
rinku
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