QMF 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 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 Environment Development will be performed using:

• QMF running on an IBM Mainframe

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.