informix 9.4 named columns from stored procedures
i am told stored procedures can now return named columns instead of it just being titled "expression". what is the syntax for doing so? thanks
↪ replying to tomL
On Thu, 22 Jan 2004 10:00:59 -0500, tomL wrote:
> i am told stored procedures can now return named columns instead of it just
> being titled "expression". what is the syntax for doing so? thanks
Add 'AS name' clause to each return variable in the RETURNING clause of the
CREATE PROCEDURE/FUNCTION statement:
CREATE FUNCTION freddy ( input INT )
RETURNING INT AS barney;
....
END FUNCTION
Art S. Kagel