大家帮看个DB2的存储过程,为什么执行不了,如下:
create procedure sales_status
(in quota integer, out sql_state integer)
dynamic result sets 1
language sql
begin
declare myresult integer;
declare rs cursor with return for
select count(*) from knowledge_list;
open rs;
set sql_state = myresult;
end报的错如下:
10:47:01 [CREATE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;are myresult integer;<psm_semicolon>, DRIVER=3.57.82
10:47:01 [DECLARE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=declare RS cursor with return for
;BEGIN-OF-STATEMENT;<space>, DRIVER=3.57.82
10:47:01 [OPEN - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;open rs;JOIN <joined_table>, DRIVER=3.57.82
10:47:01 [SET - 0 row(s), 0.000 secs] [Error Code: -206, SQL State: 42703] DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SQL_STATE, DRIVER=3.57.82
10:47:01 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;end;JOIN <joined_table>, DRIVER=3.57.82
... 5 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 5 errors]
大家帮忙解决下,非常感谢。
create procedure sales_status
(in quota integer, out sql_state integer)
dynamic result sets 1
language sql
begin
declare myresult integer;
declare rs cursor with return for
select count(*) from knowledge_list;
open rs;
set sql_state = myresult;
end报的错如下:
10:47:01 [CREATE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;are myresult integer;<psm_semicolon>, DRIVER=3.57.82
10:47:01 [DECLARE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=declare RS cursor with return for
;BEGIN-OF-STATEMENT;<space>, DRIVER=3.57.82
10:47:01 [OPEN - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;open rs;JOIN <joined_table>, DRIVER=3.57.82
10:47:01 [SET - 0 row(s), 0.000 secs] [Error Code: -206, SQL State: 42703] DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SQL_STATE, DRIVER=3.57.82
10:47:01 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;end;JOIN <joined_table>, DRIVER=3.57.82
... 5 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 5 errors]
大家帮忙解决下,非常感谢。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货