You can translate the question and the replies:

Identify all derived views using a specific function

We have a scenario where we are running into an IDMC bug that is loading all null values (for string columns) as blanks and 0 (for numeric columns). and wants to identify all derived views using functions handling nulls. Is there a way we can identify views using specific functions? Appreciate your help.
25-09-2023 13:45:52 -0400

1 Answer

Hi, I would develop a [Custom Stored Procedure in Java]( using the [Denodo4E plugin](, where your return set would be a list of columns from the VDP views that contains a specific function. Please refer to a very [similar Denodo Community Question]( that tests for similar logic. Generally, you can create the custom stored procedure, import it into Denodo’s Extension Management library, and reference example Denodo Stored Procedures as a guide. Hope this helps!
Denodo Team
25-09-2023 16:40:24 -0400
You must sign in to add an answer. If you do not have an account, you can register here