Los Angeles1
asked on
Sotred Procedure (End of file)
I read the following doc:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.apdv.plsql.doc%2Fdoc%2Ft0053609.html
and then executed my command to read in my stored procedure, and got much further
but did not quite complete the work, this is the stored procedure:
This is the command I used to eliminate the semicolon errors:
However, it still has a problem of hitting the EOF, even if I terminate the last line with a semi-colon
Any ideas ?
Thanks
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.apdv.plsql.doc%2Fdoc%2Ft0053609.html
and then executed my command to read in my stored procedure, and got much further
but did not quite complete the work, this is the stored procedure:
[db2inst1@sandbox1 ddl]$ cat hello.sql
CREATE procedure DropIt ()
LANGUAGE SQL
modifies sql data
BEGIN
drop table deleteme cascade;
commit;
END;
This is the command I used to eliminate the semicolon errors:
[db2inst1@sandbox1 ddl]$ db2 -td/ -vf hello.sql
DB21007E End of file reached while reading the command.
However, it still has a problem of hitting the EOF, even if I terminate the last line with a semi-colon
Any ideas ?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.