Update large number of Base Views Column Descriptions from another base view

Version 7.0, I have 7 systems and other 100 tables that are in Base Views. I want to update column descriptions from a Data Dictionary that is in another base view and I also have the Dictionary in a Excel file. Please tell me the steps, or point me to an article, or somewhere in the documentation that shows me how to do this. My dictionary has fields; TABLE_NAME and COLUMN_NAME. The 100 tables have column names that may or may not have column_names in the directory. I should add that the descriptions were NOT in the Oracle database that I was connecting to, there were maintained in a separate and independent table.
user
29-01-2019 15:50:49 -0500

1 Answer

Hi, One way you could possibly do this is by writing a script or program. The program would connect to Denodo using JDBC, read the descriptions from the base view which contains them, and then update the columns of the other base views with these descriptions by using the ALTER TABLE command. The command would look something like this: ALTER TABLE your_baseview ( ALTER COLUMN column_to_update ADD ( DESCRIPTION = 'The new description' ) ); For more information on the ALTER TABLE command, check out this documentation: https://community.denodo.com/docs/html/browse/7.0/vdp/vql/creating_a_base_view/modifying_a_base_view/modifying_a_base_view Hope this helps.
Denodo Team
30-01-2019 08:41:33 -0500
You must sign in to add an answer. If you do not have an account, you can register here