The query text for the selected row is displayed on the SQL Text Browse panel. This is the actual SQL statement that was run in QMF. For queries stored in QMF, this may be different from the current SQL statement stored in QMF. This is the only panel from which you can browse ad hoc query text.
DB2P / DB2PLOCATION -- QMFUSER.QUERY1 ------------------------------- 8.1.0 Command ===> Scroll ===> PAGE Valid Commands Are... ANALYZE to invoke Query Analyzer (valid only for queries). Cancel Date Time TSOID SQLID Env Mode Rows CPU Code ----- ----- ------ ------ ---- ----- ---- -------- ---- --------------------------------------------------------------------------- ***************************** BOTTOM OF DATA ******************************** |
If you enter the command ANALYZE on the command line and press Enter, Query Analyzer will be invoked with the QMF query identified on this panel. This command is only valid for QMF queries. When you exit Query Analyzer, you will return to this panel.
If you press PF3, you will return to the previous panel.
If you press PF8 or PF7, the panel will scroll forward or backward.