QMF Query Identification

This section shows examples of QMF Query identification.

If a QMF query is explained by the EXPLAIN QMFQUERY command, the object identification section of the report shows the following for each SQL statement:

Full QMF query name
Statement text

For details on how to specify EXPLAIN QMFQUERY commands refer to the Report Command Reference.

Explain Identification - QMF Query

Here is an example of the QMF query identification.

QMFQUERY: USR1.MY_QUERY

--
--SELECT * FROM A CATALOG TABLE
--

  SELECT  NAME, CREATOR
    FROM SYSIBM.SYSTABLES
   WHERE CREATOR NOT LIKE 'SYSIBM%'
     AND CREATOR LIKE 'XXASP%'
  ORDER BY CREATOR, NAME

--