DB2 graphic QMF Version 8

Analyzing queries from outside of QMF

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'

Table 92. Analyze Query
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:

Query Data Set
Enter the name of the data set or data set and member containing the query to be analyzed. The data set should contain only query text and QMF-style comments.
Enter Ad Hoc Query Text Below
Enter an ad hoc query.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004