DB06 - QMF Workshop - 1 Day

Course Description

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.

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

Environment

Development will be performed using:

  • QMF running on an IBM Mainframe

Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

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.

Course Enquiry