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. AUDIENCE:   All personnel who will be working with QMF and wish a comprehensive overview of QMF and to develop skills in the use of QMF. PREREQUISITES:   An understanding of TSO is helpful but not necessary. This course assumes no prior knowledge of the SQL language. DURATION:   3 Days OBJECTIVES:   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 COURSE CONTENT:   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.