Informix SQL / reuse result of stored procedure in another query

Question

I want to use the result of stored procedure in another query. But I do not know the correct syntax. DBMS : IBM Informix, Stored procedure, I use.

Select col1 from table (MULTISET(EXECUTE PROCEDURE procedure ('param1','param2')))

Answer 1

This the example:

CREATE FUNCTION SF_DYN_REP_EXEC(i_sql varchar)
    RETURNING INT, VARCHAR(30);

    DEFINE ret_groupid int;
    DEFINE ret_groupname varchar(30);
    FOREACH cursor1
    FOR
        SELECT groupid,
             groupname INTO 
             ret_groupid,
             ret_groupname
        FROM tctaddinmessagegroups
        RETURN ret_groupid,
             ret_groupname WITH RESUME;
    END FOREACH;
END FUNCTION;

select vret_groupid C1,
             vret_groupname C2 from
table (function SF_DYN_REP_EXEC('blablabla'))
vtab1(vret_groupid,
             vret_groupname)
order by vret_groupid,
             vret_groupname;