Re: Q: Assigning names to values returned from a SP
Hi
Try to use the execute procedure in a select statement as
SELECT proc1(parameter1,...) MYNAME_TO_RETURN_VALUE
FROM SYSTABLES
WHERE TABID = 1;
Harinath Venkata
On Fri, 29 Aug 1997 13:20:19 -0400 Edwin Babadaglian <edwinb@panix.com>
writes:
}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. I am running OnLine
}7.12.
}
}Thanks for any ideas.
}
}Edwin Babadaglian
}edwinb@panix.com
}
}
}
}