Skip to content

RETURN ROW Example

The following is a RETURN ROW example:

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;