You can translate the question and the replies:

Delegate SQL sentence variables as parameters

Hi Team, May I know the use of "Delegate SQL sentence variables as parameters" under wrapper source configuration. I checked the below url but the particular functionality is missing https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/generating_wrappers_and_data_sources/creating_wrappers/wrapper_configuration_properties Thanks in advance
user
13-07-2022 07:37:54 -0400

1 Answer

Hello, The property **Delegate SQL sentence variables as parameters** has been included from the **Denodo Platform update(denodo-v80-update-20210715)**. The function of this property is to **delegate** the **interpolation variables** values as parameters for the **base views** which are created using **Create from query** option. **Functionality:** * Only applicable to base views created using **Create from query** option. If property is set to: * **No** (default): Interpolation variable values will not be passed as parameter. * **Yes**: Interpolation variable values will be passed as parameter. For instance, if the view has been created with the following query, Select * from <view_name> where id =@id When executing the base views it will prompt you to enter the values for the interpolation variable(In this example id). If the property **Delegate SQL sentence variables as parameters** has been configured as **yes**, then the value entered for the **interpolation variable** will be **delegated** as parameters instead of passing the value directly in the query to the **underlying source**. The documentation for the property **Delegate SQL sentence variables as parameters** will soon be added to the Denodo Community Site. Hope this helps!
Denodo Team
14-07-2022 11:42:51 -0400
You must sign in to add an answer. If you do not have an account, you can register here