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
To have the execution trace of a query available, when executing the query from a VDP administration tool Execution panel make sure that the "Execute with TRACE" option is selected. To get the execution trace of a query executed from a VQL shell add a “TRACE” clause at the end of any query.
With these options selected, once the query finishes, to see the execution trace: