You can translate the question and the replies:

Display column description INSTEAD of column name

When building views for our business I want to display COLUMN_DESCRIPTION not column names in my views and reports. How can I display COLUMN_DESCRIPTION instead of COLUMN_NAMES in views derived from iv_views?
user
30-01-2019 11:07:39 -0500

1 Answer

Hi, First, I think it's useful to know that field and view descriptions are accessible via the JDBC driver. There's some more information on this here: https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_jdbc/details_of_the_jdbc_interface/details_of_the_jdbc_interface#description-of-views-and-their-fields There are also Denodo stored procedures which allow access to the metadata, including descriptions: https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_procedures If you want the descriptions to appear as column headers, however, you will need to update (either manually or via ALTER TABLE statements) the names of the fields. Hope this helps.
Denodo Team
01-02-2019 04:33:15 -0500
You must sign in to add an answer. If you do not have an account, you can register here