The columns in the window provide the following
information about SQL statements:
- Statement number
- The line number of the SQL statement in the source module of the
application program. For static SQL, this number corresponds to the
STMTNO column in the SYSCAT.STATEMENTS table.
- Section number
- The number of the section within the package that is associated with the
SQL statement.
- Explain snapshot
- States whether an explain snapshot has been
taken for the SQL statement. (If it has not been taken, you cannot view
an access plan graph for the statement.)
- Total cost
- The estimated total cost (in timerons) of
returning the query results for the selected SQL statement. (Available
only if the package containing the statement has
been explained previously.)
- SQL text
- The first 100 characters of the SQL statement. (Use the scroll bar
at the bottom of the window to scroll through it.)
To view the complete SQL statement, select Statement->Show SQL
text.