Home / Q&A / What is the purpose of the scalar functions checkbox on the source config screen?
You can translate the question and the replies:

What is the purpose of the scalar functions checkbox on the source config screen?

We've been working with the 'Delegate scalar functions list' property in Denodo and wanted to make sure we understood how the checkbox is intended to work. -Does the checkbox truly enable the list of functions to be delegated? So if it's un-checked it means anything listed in the grayed-out textbox will NOT be delegated? -Or is it only used to open-up the textbox to be edited when it is checked? That said, even if it is un-checked, the list of functions in the grayed-out box WILL still be delegated? We believe the 2nd bullet is correct but wanted to make sure. The UI was a little confusing to us. Thanks!
Data Source
user
16-08-2018 10:15:19 -0400

1 Answer

Hi, Yes, the checkbox is to enable editing the list of functions in the field. Virtual DataPort automatically uses suitable configurations for most common data sources. For JDBC data sources, all the scalar functions listed will be delegated to the underlying data source by default. You can disable the delegation of a certain function by removing it from the list. You can check if the functions are delegated by viewing the Execution Trace tab found in the Query Results after executing a statement. You can refer to the [Data Source Configuration Properties](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/data_source_configuration_properties/data_source_configuration_properties) and [Execution Trace of a Statement](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/querying_views/execution_trace_of_a_statement) section of the Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
17-08-2018 02:14:48 -0400
You must sign in to add an answer. If you do not have an account, you can register here