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.
27-01-2023 05:08:25 -0500

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]( section of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
27-01-2023 15:14:22 -0500
You must sign in to add an answer. If you do not have an account, you can register here