I am able to use the LIST VIEWSTATSUMMARYS as an input for parameters in Scheduler by following those steps:
1. Create a data source in Virtual DataPort, using a JDBC data source of type VDP pointing to itself.
2. Then you would create a base view - one from a query, where you would insert the LIST VIEWSTATSUMMARIES statement.
3. On the view that you created, click in “Options” > “Search Methods” (Wrapper Source Configuration) > Set Delegate SQL Sentence as Subquery to “No”, so that only the LIST VIEWSTATSUMMARIES statement is executed and not turned into a select statement that would not work, so that the LIST command will not be delegated as a subselect.
4. Once you have done that, you should then create a job on Denodo Scheduler where you would insert the call you wrote, where you would insert the call and provide the appropriate mapping from the new base view and the parameter @myview.
,null, true, false, false, true).
All should work now!
Hope this helps!