You can translate the question and the replies:

Extract CREATE VIEW AS SELECT soruce code statement

Hi, We are trying to ONLY extract all the CREATE VIEW vql source code to be able to isolate the AS SELECT statement of it. The goal is to have a list of all views we have created and their select statement. Can the output of the feature 'Creating revisions from compare environments wizard (DENODO PLATFORM 8.0)' be extracted to a TEXT file? Is there a Denodo script to PARSE OUT from the databse export the AS SELECT statement source code? Any ideas? Thanks.
user
05-04-2023 15:08:32 -0400
code

1 Answer

Hi, Related to getting the VQL source code of the views I’ve found two similar questions that you should check:[ Fetching VQL](https://community.denodo.com/answers/question/details?questionId=9060g000000fzELAAY&title=Fetching+VQL) and[ Displaying VQL for all Data Sources](https://community.denodo.com/answers/question/details?questionId=9060g0000000AaRAAU&title=Displaying+VQL+for+all+Data+Sources+in+Denodo). There, you can see different ways to get the VQL file of the views. In order to obtain the VQL File in [the Create Revisions from compare environments wizard](https://community.denodo.com/docs/html/browse/8.0/en/solution_manager/administration/promotions/revisions_from_differences_wizard/revisions_from_differences_wizard#compare-environments-wizard) you have to select the environments to compare. Then, you can select all the elements and jobs that the revision will include and create it. Finally, you can go to Promotions > Revisions > Click on the Download Icon of the revision > Download VQL. Hope this helps!
Denodo Team
10-04-2023 08:03:27 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here