Output column names for query result sets are generated by the source database. When you apply a function to an attribute in a query, the output column name is different for different databases and may bear no relation to the source column name. You can define custom column names to be used as port attribute names and displayed in the Data Viewer, by adding column aliases when you enter queries.
For example, when querying an ASE database using an aggregate function, the Content Browser displays the results of the query without a column header for the aggregated data column. To add a column header, add an alias value on the same row as the attribute, which utilizes the aggregate function. If the query is:
SELECT COUNT (qsID) FROM TAB_IDS, add an alias value to the returnedcolumn as follows:
SELECT COUNT (qsID) AS qsID_COUNT FROM TAB_IDS
