Query Analyzer can be used to process queries outside of QMF, such as ad hoc queries, exported QMF queries, and SPUFI queries. Selecting option 1 from the Query Analyzer Selection Menu brings you to the Analyze Query panel. You can also invoke this panel by issuing the following TSO command:
CALL 'QMFHPO.SRAALOAD(RAAMAIN)' 'QA 1'
DB2P -- Analyze Query ------------------------------------------------ 8.1.0 Command ===> Press ENTER to analyze a query from one of the following input sources. Type CAN or CANCEL or press PF3 to end. 1. Query Data Set ===> 2. Or Enter Ad Hoc Query Text Below===> ===> ===> ===> ===> ===> ===> ===> ===> ===> ===> ===> |
If you press Enter, the specified query will be analyzed. If any errors are detected, the panel will be redisplayed with an error message. Otherwise, the analysis data will be passed to the exit routine identified on the Set Default Parameters panel.
If you press PF3, all input fields will be ignored and you will return to the Query Analyzer Selection Menu.
The fields on the panel are: