Procedure dynamic result set column names

Database

Procedure dynamic result set column names

When I call the procedure below in SQL Assistant, the data is returned ok, but without column headers...  Is there any way to include the column headers (e.g., in this case, 'DatabaseName','TableName',etc)?

replace PROCEDURE abc()

dynamic result sets 1

begin

     DECLARE SqlStr VARCHAR(100);

     DECLARE cursor_1 CURSOR WITH RETURN only FOR statement_1;

     set SqlStr='select top 10  * from dbc.Tables';

     prepare statement_1  from SqlStr ;

     open cursor_1;

end

2 REPLIES
N/A

Re: Procedure dynamic result set column names

It's working fine for me, what's your SQLA release?

Re: Procedure dynamic result set column names

15.00

I've just tried it in an old SQLA, and it is returning column names as expected...  Even having reinstalled 15.00 the issue persists - is there a setting somewhere for this functionality, do you know?