informix能否在存储过程里面返回结果集（多行记录) 一个例子

create procedure aproc ( val int ) returning int ,char(20);

define v1 like zz.a1;
define v2 like zz.a2;

foreach select a1,a2 into v1,v2 from zz where id = val
return v1,v2 with resume ;
end foreach;
end procedure ;