Re: Q: Assigning names to values returned from SP

Edwin Babadaglian (edwinb@panix.com) wrote: : I am writing a Java applet that executes a stored procedure that returns : rows. I would like to use names rather that indexes to refer to a : column. If I execute the procedure from dbaccess, I get all columns : labeled '(expression)'. I've tried using the 'AS' keyword in the return : statement's column list but that's a syntax error. : Thanks for any ideas. : Edwin Babadaglian : edwinb@panix.com Try: SELECT integer1*integer2 product_of_integers FROM yourtable WHERE whatever_you_want; The number integer1*integer2 will be called "product_of_integers" Note that there is no comma between integer2 and product_of_integers. Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" Slaving away on "INFORMIX DEBUGGERS Survival Guide", available early 1998 from Prentice Hall/Informix Press. If you have debugging tips, tools, or ideas to share, please send me some e-mail. ---------------------------------------------------------------------------