DB2 Query Management Facility by siz19146


									                                       COURSE OVERVIEW

                                            (Course No. 180.021)

The Query Management Facility (QMF) is a powerful tool for interactive ad hoc queries or report writing from
data stored in either DB2 or SQL/DS. Although the course focuses on the use of QMF with DB2, the content
applies equally to the use of QMF with SQL/DS.

QMF is interactive, and all of its functions can be used online, from creating and modifying a query to printing
a report. QMF commands are simple, and knowledge of just a few commands will enable you to be
productive. Hence QMF can benefit a variety of users, even if they know nothing about data processing

QMF is widely used, with an ever increasing number of organizations recognising its benefits within the user
community. This course has already enabled numerous users, from every conceivable background, to
produce quality reports tailored to their specific requirements, without the need for complex programs or
lengthy delays and without having to rely on technical staff. QMF is so easy that it lets the user concentrate
on "what is to be done" rather than "how to do it".

The course also promotes a standard structure for end-user queries, which contributes to an orderly and
uniform reporting environment. These conventions rest on common sense. They permit the sharing of QMF
work and avoid duplication with its resulting loss of productivity.

The QMF course will enable all participants to:
•       access data kept in DB2 or SQL/DS tables
•       perform calculations on that data
•       produce and print reports in many different formats
•       work interactively with QMF and other products.

                                            InterSkill Pty Ltd
                                          COURSE AGENDA


1.   DB2 OVERVIEW                                6.   CREATING a PROC

     DB2                                              Sample PROC
     DB2 Tables                                       Saving a PROC
     DB2 Databases                                    Running a PROC
     DB2 Tablespaces                                  Errors during running of a PROC
     Security                                         Specifying Variables in a PROC
     Data Retrieval
                                                 7.   MORE ABOUT SQL

2.   INTRODUCTION to QMF                              DB2 Data Access
                                                      Review of DML Statements
     What is QMF                                      SELECT Statement
     Running a QMF Command                            Clauses, Syntax, Prefixing
     Getting Started in QMF                           WHERE Clause
     The RUN Command                                  ORDER BY Clause
     Entering Variable Data for Queries               Predicates
     DISPLAY List of Queries or PROCs                 Comparisons
     Viewing Query Output                             BETWEEN
     Interrupting QMF Command Execution               NULL
     Ending a QMF Session                             IN
                                                      Coding a Basic SELECT Statement
3.   CREATING a QMF Query                             SELECT Built-in Functions
                                                      CURRENT DATE, CURRENT TIME, USER
     Creating a New Query                             Using Expressions
     Changing Query Language                          Scalar Functions
     QMF Profile                                      GROUP BY
     Format of an SQL Query                           HAVING
     Rules and Restrictions for Queries               DISTINCT
     Entering a Query                                 Creating a Table, Data Types
     The DRAW Subcommand                              Adding Data to a DB2 Table
     Query Editing Tools                              Modifying DB2 Data
     Naming Your Query                                Deleting DB2 Data
     QMF Temporary Areas                              Processing Multiple Tables
     Help Facility                                    Joining Tables
                                                      Correlation Names
                                                      SELECT from Multiple Tables

     The DISPLAY FORM Panel                      8.   QUERY BY EXAMPLE (QBE)
     Page Headings and Footings
     Checking Changes to a Form                       Getting Started in QBE
     Viewing Changes to a Form                        Specifying Variables in QBE
     Running a Query with a Form                      Running a QBE Query
                                                      More about conditions and calculations
                                                      Inserting Data into a Table
5.   CREATING QUERIES for OTHERS                      Updating a Column in a Table
                                                      Deleting a Row in a Table
     Incorporating Variables in a Query
There is no need to be a programmer to use QMF. Secretaries, clerks, managers, administrators, application
programmers, engineers, and scientists also effectively use it.
Anyone working within an DB2/SQL or SQL/DS environment, no matter how little information processing
experience they have, should attend this course.

The InterSkill course "DB2/SQL Overview" is a desirable prerequisite for this course.

Duration:    3 Days
Class size: Maximum 12

The course is a three-day "hands-on" workshop. The course employs a LISTEN, WATCH, DO approach,
moving participants from a lecture-style learning process to an experiential one.
Introduction of each new concept and software stucture is supported by practice and problem-solving
All those attending will receive bound copies of the course materials.

This course will enable participants to:
•       produce quality reports using QMF with little reliance on technical support staff
•       start using QMF with a knowledge of industry standards
•       be aware of performance issues and efficiency techniques
•       use QMF in a way that promotes further progress through the Advanced QMF course.

                                            InterSkill Pty Ltd

To top