DB06 - QMF Workshop
Duration1 Day
AvailabilityCheck course price and availability

Target Audience

This training course teaches the delegate how QMF (Query Management Facility) can be used to create queries, reports, forms and procedures. It is aimed at those who have little or no previous QMF experience but already know SQL.

Pre-requisites

A working knowledge of how SQL can be used to read, manipulate and join tables is required. This can be gained by attending course DB08 - SQL Workshop.

Course Objectives

The aim of this course is to provide the delegate with the necessary skills to produce simple and complex QMF reports. On completion of this course the student will be able to:

  •     use QMF to create a QUERY
  •     use QMF to create a FORM
  •     use QMF to create a PROCEDURE
  •     use QMF to create a REPORT
  •     use QBE and PROMPTED query writing modes
  •     use QMF to EXPORT and IMPORT data

Course Environment

Development will be performed using:

  •     QMF running on an IBM Mainframe

Course Details

QMF
QMF Home Panel
The Retrieve Command
QMF Storage Areas
Saving an Object
Retrieving an Object
Export and Import
Printing reports
WRITING QUERIES
Introduction
Entering Queries
The DRAW Command
The EDIT Command
QBE Commands
Enlarge/Reduce
Using Elements in QBE
QBe Conditions Box
Joining Tables in QBE
Using Variables in SQL Or QBE
The QMF Table Editor
FORMATTING REPORTS
The FORM.MAIN Panel
The FORM.COLUMNS Panel
The FORM.PAGE Panel
The FORM.DETAIL Panel
The FORM.FINAL Panel
The FORM.BREAKn Panel
The FORM.OPTIONS Panel
The FORM.CONDITIONS Panel
The FORM.CALC Panel
The SHOW Command
PROCEDURES
Introduction to Procedures
Creating a Procedure
Variables in Procedures

Course Format

The course contains many practical exercises to ensure familiarity with the product. Using QMF the delegate will write many queries, forms and procedures. The comprehensive Student Guide supplied is fully indexed serving as a useful reference tool long after the course has finished. Delegates will also be able to access a free help-line with technical questions relating to topics covered on the course.