AUDIENCE:   All personnel working with QMF who require a comprehensive overview of QMF in order to develop their skills in its use. PREREQUISITES:   An understanding of TSO is helpful but not necessary. The course assumes no prior knowledge of the SQL language. DURATION:   2 days. Hands on. OBJECTIVES:   This course provides a solid introduction to IBM's Query Management Facility (QMF). Machine labs are used extensively to provide greater familiarity with QMF. The course uses lecture, paper exercises and hands-on workshops. After completing the course, delegates will understand: - The objects, which 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 Obtaining help The SHOW command Retrieving a command Ending a QMF session Using Prompted Query Getting started with Prompted Query Prompted Query panels Obtaining help in Prompted Query Prompted Query commands Using SQL Queries Format of SQL Queries Creating an SQL Query Running a query Changing an SQL Query Selecting and organising SQL Query data Selecting on conditions Using Calculated Values Selecting from Multiple Tasks 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 and changing a Format Control columns and usage codes Obtaining 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 IC07/01