你的procedure里面有begin没有end,最后加上end就可以了。C:\WORK>db2 -td@ -f 1.txtDB20000I SQL命令成功完成。C:\WORK>more 1.txtCREATE PROCEDURE sales_status(IN quota INTEGER, OUT sql_state CHAR(5))DYNAMIC RESULT SETS 1LANGUAGE SQLBEGIN &nbs...
显示全部你的procedure里面有begin没有end,最后加上end就可以了。
C:\WORK>db2 -td@ -f 1.txt
DB20000I SQL命令成功完成。
C:\WORK>more 1.txt
CREATE PROCEDURE sales_status
(IN quota INTEGER, OUT sql_state CHAR(5))
DYNAMIC RESULT SETS 1
LANGUAGE SQL
BEGIN
DECLARE SQLSTATE CHAR(5);
DECLARE rs CURSOR WITH RETURN FOR
SELECT * from test fetch first 1 rows only;
OPEN rs;
SET sql_state = SQLSTATE;
End
@
收起