column names in stored procedure return

Posted in 2009

Topics: Stored Procedures & SPL, Versions, Editions & End-of-Life

Gentian Hila — Tue, 17 Mar 2009 16:30:24 -0400 — source: Usenet: comp.databases.informix

Is it possible to have column names in the result of Stored Procedure? (IDS 9.40)

↪ replying to Gentian Hila

Fernando Nunes — Tue, 17 Mar 2009 21:15:44 +0000 — source: Usenet: comp.databases.informix

Gentian Hila wrote: > Is it possible to have column names in the result of Stored Procedure? > > (IDS 9.40) http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqls.doc/sqls1160.htm This is from IDS 10, but it should be the same in 9.4 according to it's PDF documentation... "RETURN .... AS column_name" Please test. By the way... you're running out of time... 9.40 will enter EOS soon. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...