CREATE PROCEDURE rowproc ... AS
    ... RESULT ROW (CHAR(8), INT, FLOAT) ...
BEGIN
    ...
    FOR SELECT department, COUNT(*), AVG(salary) INTO :a, :b, :c FROM personnel
        GROUP BY deptname DO
    ...
   RETURN ROW (:a, :b, :c);
    ENDFOR;
     ...
  END;