Oninit cdi / Archive
Talk to an expert →

RE: informix 9.4 named columns from stored procedures

Posted in 2004

Topics: SQL Development & Query Writing, Stored Procedures & SPL

Tsutomu Ogiwara — — source: Usenet: comp.databases.informix

Hi. Try the following. select zzz() return_from_proc where tabid = 1; --- create procecure zzz (returning char(10)); return "ZZZ"; end procedure --- Results return_from_proc ZZZ -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: tomcaml@yahoo.com (tomL) >Reply-To: tomcaml@yahoo.com (tomL) >To: informix-list@iiug.org >Subject: informix 9.4 named columns from stored procedures >Date: 22 Jan 2004 07:00:59 -0800 > >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 photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail sending to informix-list

↪ replying to Tsutomu Ogiwara
scottishpoet — — source: Usenet: comp.databases.informix

In 9.30 and 9.40 it is possible to do .... select get_code_desc(1) from systables where tabid = 1; which returns : (expression) wk_desc and : select get_code_dec(1) type from systables where tabid = 1; which returns : type wk_desc The change that occurred in 9.40 relates to the behaviour of "execute procedure". June has already given and example.

↪ replying to scottishpoet
June C. Hunt — — source: Usenet: comp.databases.informix

scottishpoet wrote: > In 9.30 and 9.40 it is possible to do .... > > select get_code_desc(1) from systables where tabid = 1; > > which returns : > > (expression) > > wk_desc > > and : > > select get_code_dec(1) type from systables where tabid = 1; > > which returns : > > type > > wk_desc > > The change that occurred in 9.40 relates to the behaviour of "execute > procedure". June has already given and example. Art gets the credit for the 'execute procedure' example. I simply tried the examples posted by both Tom and Art and reported the results. -- June Hunt

Related threads