Print this Page

QMF: Query Management Facility

Abstract
(2 Days)

This course provides an introductory treatment of the QMF query management facility running under DB2.  It provides thorough instruction in Prompted mode and SQL mode.  It includes a rudimentary treatment of SQL to allow students to use SQL mode.  Upon completion, students should be able to execute, store and retrieve basic QMF queries, as well as print them using the report writing facilities.  In addition, procedures are covered to allow students to develop a series of SQL statements in a stored form.

Audience

This course is open to anyone having a knowledge of the basic organization and structure of a relational database (DB2 in particular).  Students do not need to know SQL.  A small subset of SQL will be taught in order to learn the use of SQL mode.

Topics

• Basic QMF commands

• Forming queries - Prompted Mode

• Forming queries - SQL Mode

• Saving/retrieving queries, formats, data, reports, etc.

• Report writing and formatting - headers and footers, control breaks, vertical functions, multi-line displays

• Procedures

• Parameters in queries and procedures

• The QMF DATA object - taking snapshots of a table

• Advanced form topics

  • GROUP and ACROSS

  • FORM.PAGE

  • FORM.DETAIL - Advanced formatting of table rows into multiple output lines or block text mixing column and tabular data.

  • FORM.OPTIONS

  • FORM.CALC

• Advanced editing codes

• Use of QMF with TSO CLISTs, editors, programs and other products

• Using QMF to produce charts and graphs

• Batch execution

• Importing and exporting QMF objects

Supervised Exercises

This course will be accompanied by a set of exercises to reinforce the classroom material.