Column names returned by a SPL
Hy,
Is it possible to assign a column names to the resultset of a SPL (which
returns values) ?
CREATE FUNCTION FuncColumnName()
returning VARCHAR(255);
DEFINE _tabname VARCHAR(255);
FOREACH
SELECT tabname
INTO _tabname
FROM systables
RETURN _tabname WITH RESUME;
END FOREACH;
END FUNCTION;
--------------------
EXECUTE PROCEDURE FuncColumnName();
The name of the result column is (expression) !!! Can I assign an other
column name ??
Regards,
Stefan