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
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 ;
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?