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.
user
25-09-2023 13:45:52 -0400
code

1 Answer

Hi, I would develop a [Custom Stored Procedure in Java](https://community.denodo.com/docs/html/browse/8.0/en//vdp/developer/developing_extensions/developing_stored_procedures/developing_stored_procedures) using the [Denodo4E plugin](https://community.denodo.com/tutorials/browse/customcomponents/1denodo4e), 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](https://community.denodo.com/answers/question/details?questionId=9064u000000L86AAAS&title=How+to+search+for+%2F+list+in+Denodo+columns+%28of+a+view%29+that+make+use+of+a+certain+function%3F) 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
code
You must sign in to add an answer. If you do not have an account, you can register here