Re: SPL Returning Column Names

Thanks for the reply. Unfortunately the problem is not with the syntax I am using. The problem is that there is no column names associated with fname, nrows. I get the returned data just fine. Normally if you did a select fname, nrows from table. The returned data would have a column name of 'fname' and 'nrows' that is associated with the data. In a stored procedure only the values are returned, their is no name associated with the values. This is what prompted my question: Is there anyway to return data and a column name for that data from a stored procedure? Thanks --Sco Dennis Robinson <drrobin@vsol.com> wrote in article <53b2jg$jme@cssun.mathcs.emory.edu>... > > > ---------- > From: Charles Smith[SMTP:csmith@vsol.com] > Sent: Saturday, October 05, 1996 3:07 PM > To: 'Dennis Robinson' > Subject: FW: SPL Returning Column Names > > Dennis: > When you create a stored procedute the next line should look like this > ' RETURNING CHAR(15), INT;' > other stuff > > at the return should look like > 'RETURN fname,nrows' > > > Example on page 12-26 SQL Tutorial Version 7.2 > > Hope this helps > Charles.