You can translate the question and the replies:

Invalid Views list.

Hi team , I am using Denodo 8.0 Verssion. Please let me know how do I bring list of All Invalid Views and associations ( including Base , Integration , Derived , staging , Business views ) in tabular format. I tried to execute desc database <database name> but it is not giving result as per the requirement. I want all the other details in tablular format along with the status of the view as invalid incase any of view or interface is invalid . Please help here.
Views
user
27-01-2023 05:08:25 -0500
code

1 Answer

Hi, I used the stored procedure GET_VIEWS() to produce a list of invalid views in tabular format. Here is the VQL: `SELECT * FROM GET_VIEWS() WHERE input_retrieve_invalid_views_only=TRUE` For more details, you can refer to the [GET_VIEWS](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_views) section of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
27-01-2023 15:14:22 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here