Query Management Facility (QMF) Workshop

Course: QMF3

Duration: 3 Days

Level: I

Course Summary

This course is a basic introduction to IBM's Query Management Facility (QMF), IBM's Relational Data Base Ad-hoc Query tool. It will present to the student a comprehensive overview of the QMF Product and how it relates to their current environment. Machine labs are used extensively to provide greater familiarity with QMF. The course utilizes lecture, paper, and hands-on workshops to meet its objectives.

« Hide The Details

Topics Covered In This Course

INTRODUCTION TO QMF

QMF Features
QMF Basics
How QMF Helps you
How QMF Works
- Objects in Temporary Storage
- The Relationship of Query, Data, Report and Chart
Using QMF Application Support Facilities

GETTING STARTED WITH QMF

Stored Data
Starting a QMF session
Getting Help
The SHOW Command
Retrieving a command
Ending the QMF Session

USING PROMPTED QUERY

Getting started with Prompted Query
Prompted Query Panels
Getting help in prompted Query
Prompted Query Commands
Prompted Query Exercises

USING SQL QUERIES

Format of SQL Queries
Creating an SQL Query
Running a Query
Changing an SQL Query
Selecting and Organizing SQL Query data
Selecting on conditions
Using calculated values
Selecting from Multiple Tables
SQL Query exercises

GENERAL QUERY TASKS

Interrupting a Query
Viewing the Results of a Query - The Report
Scrolling the Report
Saving a Query
Listing Saved Queries
Displaying Saved Queries
Converting a Query

USING FORMS TO FORMAT REPORTS

Formatting
Changing a Form
Control Columns and Usage Codes
Getting Help
Form Exercises

DISPLAYING REPORTS AS CHARTS

Where Data appears on a Chart
Using Form Panels to Change your Chart
Changing Chart Type
Saving a Chart
Chart Exercises

USING THE TABLE EDITOR

Copying a Table
Adding Rows to a Table
Changing Rows in a Table
Table Editor Exercises

ADVANCED TOPICS

Creating a Query and Form for Use by Others
Using Models and Variables
Creating a Procedure
Creating and Maintaining Tables
Exporting and Importing Objects
Using the Database Object List

Note: This can also be presented as a 2 day class.

What You Can Expect

The objects that comprise a Relational Database
The tabular format of data, and how these tables are related
The components that make up the QMF Product
The QMF Environment and its facilities
Basic SQL Syntax
How to build Queries in QMF
How to use forms to tailor reports from query results
How to create graphic displays of reports
How to build QMF Procedures

Who Should Take This Course

All personnel who will be working with QMF and wish a comprehensive overview of QMF and to develop skills in the use of QMF.

Recommended Prerequisites

An understanding of TSO is helpful but not necessary. This course assumes no prior knowledge of the SQL language.

« Hide The Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]