［错误］ 脚本行：24-24，麻烦大家给看下是哪儿出错了，先谢了

Question

create or replace function F_GETDATE_BY_Q(p_quarter integer)language sqlspecific F_GETDATE_BY_Qreturns varchar(8)begin atomicdeclare v_result varchar(8);declare v_current_date varchar(8);declare v_date_of_quarter_end varchar(8);declare v_date_of_quarter_begin varchar(8);set v_current_date = (select to_char(current date,'YYYYMMDD') from sysibm.sysdummy1);set v_date_of_quarter_end = (select max(biz_date) from f_com_com_date where year = year(current date) and q = p_quarter);set v_date_of_quarter_begin = (select min(biz_date) from f_com_com_date where year = year(current date) and q = p_quarter);if (v_current_date < v_date_of_quarter_begin) thenset v_result = '19000230';else if (v_current_date >= v_date_of_quarter_begin and v_current_date <= v_date_of_quarter_end) thenset v_result = v_current_date;else if (v_current_date > v_date_of_quarter_end) thenset v_result = v_date_of_quarter_end;end if;return v_result;end>［错误］ 脚本行：24-24 -------------------------------------An unexpected token "END-OF-STATEMENT" was found following "end". Expected tokens may include: "JOIN <joined_table>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.53.71

Answer 1

你是怎么执行的脚本呢？ 使用db2 -td# proc.sql这样执行的吗?
那样的话，你需要在procedure的末尾end的后面加一个‘#’符号，表示结束。
如下：
return v_result;
end #

另外data studio 没用过， 不过你可以把它copy到文件里，然后再命令行里面执行。