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]