Re: retrieving column name in stored procedure

Posted in 2005

Art S. Kagel — Wed, 14 Dec 2005 16:10:37 -0500 — source: Usenet: comp.databases.informix

Nirmala Kesavan wrote: > hi, > > is it possible to retrieve the column name or variable name instead of EXPRESSION as a column name in a stored procedure while returning the values . Depends on what version of IDS you're using (always good to tell us, BTW). In 9.4+ you can specify labels for multiple return values from a stored procedure. Syntax is: create procedure barney( ) returning int as first_col, char(12) as second_col; Art S. Kagel