Managing tables used by SQL explain

If you want to select functions to support the use of the SQL EXPLAIN statement, select option 5 (Utility) on the SQL Prototyping, Execution and Analysis panel.

When you select this option, FM/Db2 displays the Explain Utilities panel. This panel lets you create and delete the tables used by the SQL EXPLAIN statement. For additional information about the tables used by the SQL EXPLAIN statement, see the DB2 for z/OS SQL Reference.

Use the Explain Utilities panel to specify the type of function you want to perform. For more details about using this panel, refer to the reference sections.

Related tasks

• Entering, executing, and explaining SQL statements

Related references

• SQL Prototyping, Execution and Analysis panel
• Explain Utilities panel