I read the following doc:
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 ()
modifies sql data
drop table deleteme cascade;
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 ?