create procedure read_table((可以加参数))
returning char(15),char(10),......;---你需要返回的列表
define name char(20);
define city char(10);
.....
select *
into name,city
from yourtable
(where ......)
算了，我自己解决了。这分白送了
CREATE PROCEDURE gmcc.proc1()
returning integer;
define n integer;
foreach
select col into n from table1
return n with resume;
end foreach;
end procedure;
