一个最简单的游标
create procedure testpro(dates varchar(11))
language sql

BEGIN ATOMIC
DECLARE strs CHAR(40);
FOR vl AS
select str from test
do
SET fullname = str;
insert into target values(dates,strs);
END FOR
END

Error:
SQL0104N 在 "); END FOR END " 之后发现意外的标记 "END-OF-STATEMENT "。期望的标记可能包括： " <psm_semicolon> "。 LINE NUMBER=12. SQLSTATE=42601
(State:42601, Native Code: FFFFFF98)

[解决办法]
需要游标吗？