Link to home
Start Free TrialLog in
Avatar of Los Angeles1
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:

[db2inst1@sandbox1 ddl]$ cat hello.sql
CREATE procedure DropIt ()
  LANGUAGE SQL
  modifies sql data
BEGIN
   drop table deleteme cascade;
   commit;
END;

Open in new window


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.

Open in new window


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
Avatar of momi_sabag
momi_sabag
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial