retrieving column name in stored procedure
This is a discussion on retrieving column name in stored procedure within the Informix forums, part of the Database Server Software category; --> hi, is it possible to retrieve the column name or variable name instead of EXPRESSION as a column name ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 10:52 AM
| ||||
| ||||
 retrieving column name in stored procedure hi, is it possible to retrieve the column name or variable name instead of EXPRESSION as a column name in a stored procedure while returning the values . Thanks and regards, Nirmala K --------------------------------- Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping sending to informix-list      |
|
04-20-2008, 10:52 AM
| |||
| |||
| Re: retrieving column name in stored procedure is this: select somefunc(somecol) mydisplayval, col1 , col2 from sometable what you want?? Superboer Nirmala Kesavan schreef: > hi, > > is it possible to retrieve the column name or variable name instead of EXPRESSION as a column name in a stored procedure while returning the values . > > Thanks and regards, > > Nirmala K > > > --------------------------------- > Yahoo! Shopping > Find Great Deals on Holiday Gifts at Yahoo! Shopping > sending to informix-list |
|
04-20-2008, 10:53 AM
| ||||
| ||||
| Re: retrieving column name in stored procedure Nirmala Kesavan wrote: > hi, > > is it possible to retrieve the column name or variable name instead of EXPRESSION as a column name in a stored procedure while returning the values . Depends on what version of IDS you're using (always good to tell us, BTW). In 9.4+ you can specify labels for multiple return values from a stored procedure. Syntax is: create procedure barney( ) returning int as first_col, char(12) as second_col; Art S. Kagel |
Linear Mode
