网上拷贝的一个简单存储过程很简单例子，不知道为啥出错

zhaoqinghu

$ db2level
DB21085I  Instance "fexuser" uses "64" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.1.64", "s040812", "U498350", and FixPak "7".
Product is installed at "/usr/opt/db2_08_01".

$



$ cat 8.sql
CREATE PROCEDURE get_datetime (out cdate date, out ctime time )
P1: BEGIN
        VALUES CURRENT DATE INTO cdate;
        VALUES CURRENT TIME INTO ctime;
END P1;

$


$ db2 -tvf 8.sql
CREATE PROCEDURE get_datetime (out cdate date, out ctime time )
P1: BEGIN
        VALUES CURRENT DATE INTO cdate
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "END-OF-STATEMENT" was found following "RENT
DATE INTO cdate".  Expected tokens may include:  "<psm_semicolon>".  LINE
NUMBER=3.  SQLSTATE=42601

VALUES CURRENT TIME INTO ctime
SQL0104N  An unexpected token "CTIME" was found following "".  Expected tokens
may include:  "".  SQLSTATE=42601

END P1
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "END-OF-STATEMENT" was found following "END P1".
Expected tokens may include:  "JOIN <joined_table>".  SQLSTATE=42601

$

大梦

行分隔符的问题！
用db2 -td @ -vf 8.sql
在8.sql最后一行加上@