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