RE: Stored Procedure Result sets

["Neill Harper" <neill.harper@xxxxxxxx>]

I'd like to be able to have the column names as something other than the
field names in the data structure.

Just like in SQL where you can use the "AS" statement. i.e.

Select a as A_More_Descriptive_Name , b as Verbose_Text from AFile


To pre-empt questions about changing the names of the fields in the array,
it is a Synon generated array so I'd like to override the names to something
more meaningful


Neill 
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: 08 April 2009 20:03
To: 'Midrange Systems Technical Discussion'
Subject: RE: Stored Procedure Result sets

What do you mean by override?  The column name will be the name of the field
as described in the data structure

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Neill Harper
Sent: Wednesday, April 08, 2009 2:58 PM
To: 'Midrange Systems Technical Discussion'
Subject: Stored Procedure Result sets

Anybody know of a way to override the Result set column name generated by
the following:

 

SET RESULT SETS ARRAY :X FOR :Y ROWS

 

Where is X is a multi occurrence data structure.

 

Thanks

 

Neill