EXPLAIN QMFQUERY specifications

This section describes the EXPLAIN QMFQUERY specifications.

Usage

Use this specification to check if a saved QMF query is written in the SQL language.

Usage notes

  • QBE and PROMPTED queries must be converted to SQL before they can be explained.
  • Apart from explaining your own saved QMF queries, you can explain a query created by other users provided that the query was saved with SHARE=YES.
  • The QMF query can contain parameters, for example PARM1 and &PARM1; These parameters can also substitute column names in the select list. However, the query must not contain literals and other strings with one or more ampersands (&), enclosed between quotes ('). If there is more than one entry in the PLAN_TABLE with the same identifiers (for example, query number, plan name, and program name), a report for the most recent entry is produced.

Syntax of the EXPLAIN QMFQUERY specification

Read syntax diagramSkip visual syntax diagramEXPLAIN QMFQUERY( authid qmf query name )SSID1(DB2 subsystem id)SQLID(secondary authidUSER)LEVEL(DETAILBASICINDEXESKEYDISTSQLSUMMARYNORAWXPL)INDEX(YESNOALL)DEGREE(1ANYDSJESJ)
Notes:
  • 1 SSID is required unless specified in a preceding GLOBAL command.

Subcommand options

Note: This section only explains specific subcommand options. The other subcommand options are described in Subcommands and options. The following list gives additional or specific descriptions of selected options, where appropriate.
authid
qmf query name
Identify the saved QMF query to be explained.