EXPLAIN primary command

The EXPLAIN primary command explains the SQL statements in the statement entry area. FM/Db2 builds an SQL EXPLAIN statement using the contents of the statement entry area to build the FOR clause. If applicable, FM/Db2 also builds a SET QUERYNO clause using the contents of the Query number option or a generated value.

When you use the EXPLAIN primary command, FM/Db2 shows the information obtained by the generated SQL EXPLAIN statement in the Plan Table Rows panel.

Syntax


1 EXPLAIN

Availability

Related tasks