RE: Procedure (expression) output

Posted in 2001

Parker, Jack — Tue, 6 Feb 2001 15:56:18 -0500 — source: Informix-list mailing list archive (1991-1998)

Alias the column your selecting: select count(*) count_of_rows from systables; cheers j. > -----Original Message----- > From: michael_jn@my-deja.com [mailto:michael_jn@my-deja.com] > Sent: Tuesday, February 06, 2001 12:50 PM > To: informix-list@iiug.org > Subject: Procedure (expression) output > > > Does anybody know if the output from a call to a database > procedure can > be changed to output a field header other than "(expression)"? I am > calling a database procedure through an ODBC link, that returns > multiple outputs, and it would be nice to put something other > than "(expression)" out with the detail data. > > The versions of stuff we are running: > IDS2000 9.21.UC3 > Informix 4gl 7.30.UC5 > Linux Kernel 2.2.16 > > Any suggestions would be appreciated. > > > Sent via Deja.com > http://www.deja.com/ >