One of the items listed as a feature in the Introduction to the SQL Anywhere debugger is the following:
"Execute queries You can execute queries when execution is stopped at a breakpoint in a SQL procedure. This permits you to look at intermediate results held in temporary tables, check values in base tables, and to view the query execution plan."
I don't see any explanation anywhere of how to do that. Can anyone provide some insight into this?
asked 29 Sep '16, 17:34
You can run queries from the Debug menu using the "Query Database" pick; when you are in the debugger after hitting a breakpoint.
I do remember seeing the graphical plan part of this demonstrated once but will have to research it more. It may have involved running a query using the graphical_plan function (possibly embedded in the procedure) ...