Running Statement Detail

Each entry in the Running Statement list can be viewed in detail. The function shows:

- the status of the executing agent
- all statistics collected for the statement by SQL/MF
- the text of the statement with the hostvariables replaced by their contents (also for compiled statements)
- the name of the index (if any) used to access the data

Statement detail allows to take following actions on the SQL statement:

- force the agent running the statement
- show the lock status of the agent
- show the catalog entries for the table, table-columns and index used by the statement
- forward the statement to the SQL/Command Analysis program product for explain and analysis

Statement Detail in graphical format