You can translate the question and the replies:

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

3 Answers

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
Can you also let us know how to update the derived view DESCRIPTION . We have excel where we have all the field name and description . we need to update the description
user
10-04-2020 17:14:35 -0400
HI! I managed to edit the description of my derived views following the answer in this other question: https://community.denodo.com/answers/question/details?questionId=9060g000000TRIdAAO&title=How+to+update+the+derived+view+DESCRIPTION.++We+have+a+excel+file+which+has+field+name+and+description+.+How+to+update+the+description+field Hope it works for you!
Denodo Team
13-05-2020 03:43:25 -0400
You must sign in to add an answer. If you do not have an account, you can register here