Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at:   http://www.verhoef-training.com

103 Hillside Ave., PO Box 1515
West Caldwell, NJ 07006
Main Office:  800.631.0410
Sales Office:  800.533.3893

Query Management Facility (QMF) Workshop

Course:   QMF3
Duration:   3 Days
Level:   I
On our website at:   http://www.verhoef-training.com/courses/QMF3.html
 
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.

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
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.

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.