|
|
QMF for DB2 z/OS
| Duration: 3 days |
| Participants: End users and IS personnel. Knowledge of TSO/ISPF is helpful. No knowledge of SQL (Structured Query Language) or QMF (Query Management Facility) is assumed. |
|
Objectives:
Upon successful completion of this course you will be able to:
- Describe the relational data model. - Access DB2 data using the QMF prompted query facility. - Use the SQL select statement to retrieve the DB2 data you need. - Design and produce reports using the full range of QMF formatting capabilities. - Use REXX functions for customizing calculations in QMF report forms. - Create, execute, and save QMF procedures to automate selection and reporting processes on your job. |
| Overview: This course is especially designed and paced to teach QMF to the novice user. To accommodate requests for a QMF course that makes use of client data in workshops and examples, we provide a Customizable QMF Shell which we tailor to meet your needs. Please call us for information. |
| Prerequisites: Working knowledge of TSO ISPF/PDF. We recommend that classes not be mixed with end-users and experienced programmers. |
| Format: Lecture and hands-on computer workshops. The lecture and workshops are especially designed and paced to teach QMF to the novice user. |
|
Topic Outline:
- Introduction to QMF DB2 overview DB2 defined What is a Relational Database Management System? DB2 tables, columns and rows QMF defined QMF's relationship to DB2 Components of QMF QMF objects and workareas A typical QMF session Starting a QMF session Entering a query Displaying the results Ending the session - Using QMF's Prompted Query Facility Description and purpose of Prompted Query Modifying the User Profile Creating and executing the query Specifying the table Specifying the columns Executing the Prompted Query Modifying the Prompted Query Using expressions and summary functions Specifying row selection criteria Joining two tables Restrictions - Introduction to SQL Purpose of SQL Types of SQL: DML, DDL, DCL SELECT Statement Statement syntax Simple SELECTs and result tables Definition of terms SELECT parameters: FROM, WHERE, ORDER BY Simple predicates - More About SQL Advanced predicate logic SQL built-in functions Joining two tables Grouping results data - SQL Queries in QMF Displaying the query panel Entering a query QMF DRAW command QMF RUN command Viewing the report Modifying a query Saving a query - Report Formatting with FORM.MAIN Column headings Usage codes Indent Width Edit codes Sequence of columns Page headings, footings and final text - Control Breaks Understanding the concept of control breaks SQL control break requirements FORM.MAIN control break options FORM.BREAKs panels Using variables in control break headings and footings - Additional QMF Formatting FORM.DETAIL FORM.FINAL FORM.OPTIONS FORM.CALC Using REXX functions in QMF report forms - Using QMF Commands and Subcommands - Exporting Queries and Data (optional Export queries to PDSs Preparing data to download to a PC Downloading data to a PC - QMF Procedures Introduction to Procs Creating a Proc Executing a Proc Saving a Proc Using variables in a Proc |
|
|