Re: Stored Procedure does not show column names.

Posted in 1998

Peter Lancashire — Fri, 25 Sep 1998 17:59:21 +0100 — source: Informix-list mailing list archive (1991-1998)

rfurdzik@paulweiss.com wrote: > > ---------------------- Forwarded by Rafal Furdzik/PaulWeiss on 09/25/98 > 10:04 AM --------------------------- > > Rafal Furdzik > 09/23/98 10:47 AM > > To: informix-list@iiug.org > cc: > Subject: Stored Procedure does not show column names. > > When I run a stored procedure id does not show column names, but word > "(expression)". Does any one know how to assign aliases for columns in > stored procedures? Please help. > > Rafal Furdzik > SELECT myproc(myarg) mynewname FROM mytable WHERE ... The output in DB-Access will be headed "mynewname" instead of "(expression)". -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/