You can translate the question and the replies:

Extracting query with the hardcoded values not parameterized.

Hi, Currently we are running a query which has a lot of hard coded values. The query in its execution plan shows up like below Select <?> as column1, <?> as column2 from table; parameters = [<parameter1>, <parameter2>] How can I extract a query that is in essence like below. Select <parameter1> as column1, <parameter2> as column2 from table;
query plan Query Parameter Parameterize Execution plans
user
28-08-2018 12:55:46 -0400
code

1 Answer

Hi, You may change the data source configuration properties to have the Server generate the query with literals in it with the following steps: * Open the datasource in Virtual DataPort Administration tool * Under Configuration properties, go to Source Configuration tab * Change the option ‘Allow literal as parameter’ to ‘No’ * Save the changes Now the query in the execution plan will be displayed with the literals not parameterized. 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) section of the Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
29-08-2018 05:33:44 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here