When working with views created on top of JDBC and ODBC data sources, the Virtual DataPort query engine will push down SQL queries to the data sources to retrieve the data requested in the queries.
The information about the SQL query delegated by a view to any of these data sources is available in the execution trace of a query.
Since Denodo 8.0, the execution trace is automatically retrieved for all queries executed by the Virtual DataPort Administration Tool or by the Design Studio. For older versions of the Denodo Platform, you need to add the TRACE clause manually or select the option "Execute with TRACE" in order to retrieve the trace.
Once a query finishes, in order to see the execution trace:
Getting the SQL query of a query that has conditions
If your query is more complex and has conditions, depending on your data source configuration, it can happen that you see a SQL Sentence with question marks instead of the input values. The reason is that your data source configuration has the option Allow literal as parameter enabled. When you have that option enabled, the literals will be send as parameters and the provided values for the condition are listed separately in the parameters field below the SQL Sentence:
In such a case, you could either copy manually the different values from the below field into the SQL Sentence and insert them into the correct places. However, you could also temporarily change the setting of the data source in order to retrieve the full sql sentence without manually copying the values.
For this, you would need to use the Virtual DataPort Administration Tool in order to edit the Source Configuration of the data source. Follow these steps: