This course provides a comprehensive presentation of the capabilities and uses of QMF. In addition, the course addresses developing QMF queries using the Structured Query Language (SQL) and QMF’s “Prompted Mode” capability. Additional QMF topics include the development and uses of QMF forms, procedures, and Global Variables. Detailed examples are provided throughout the student text, and numerous hands–on workshops are provided to reinforce what is covered in class.

This course is intended for anyone who is interested in understanding the capabilities and uses of the Query Management Facility (QMF).

Upon successful completion of this course, the student will be able to:

• Understand how to develop/execute an SQL or Prompted Mode query
• Understand how to develop a QMF query that contains an Expression(s) and/or a Variables(s)
• Understand how to develop/execute a QMF form
• Understand how to develop a form that contains Breakpoints
• Understand how to develop a form that contains Calculations
• Understand how to develop a form that contains Group and/or Across capabilities
• Understand how to develop/execute a QMF Procedure
• Understand how to establish and use Global Variables
• Complete numerous “hands–on workshops”

• QMF Overview
• QMF’s Home, Help and Profile Panels
• Creating QMF Queries using SQL
• Simple Select Statements (SQL) used to Develop QMF Queries
• Creating QMF Queries using Prompted Mode
• Modifying Prompted Mode Queries/Including an Expression or a Variable in a Prompted Mode Query
• Using the FORM Panels to Create a Report Layout
• Using FORM.CALC
• Creating QMF Procedures (PROCS)
• Global Variables
• Using FORM.DETAIL
• Aligning Headings/Column Data
• Using GROUP and/or ACROSS
• Automatic Reordering of Report Columns
• QMF Command Syntax Handout

A basic knowledge of TSO/ISPF.