G565: QMF For Programmers

TTFlogo2.gif (2585 bytes)

QMF For Programmers - Topical Outline

Introduction
Overview of DB2 and QMF
The Sample Databases - Employees and Departments
Relational Operations: Select, Project, Join
Overview of DB2 SQL - the SELECT statement: WHERE clause
Basic QMF usage
Computer Exercise: A First Exploration of SQL

The Sample Databases - Projects and Activities
More complex SQL
    SELECT DISTINCT
    SELECT with multiple conditions
    SELECT with computed values
    NULL, and LIKE in SELECT statements
QMF objects
QMF commands: HELP, DISPLAY, RESET, ERASE, LIST, SHOW, SAVE
   Computer Exercise: SELECT with complex conditions

The Sample Databases - Project Activities and Activity Assignments
Aggregation and sorting in SQL
    Built-in Column Functions
    GROUP BY, HAVING and ORDER BY
SQL Built-in Scalar Functions
QMF commands: EXPORT, IMPORT
QMF variables
QMF Commands: SET / RESET / SHOW GLOBAL(S), RUN
   Computer Exercise: Data Aggregates

Joined Queries
Name Specification
QMF procedures
    Linear procedures
    Procedures with logic
   Computer Exercise: Joins

Nested queries (Subqueries)
UNION and UNION ALL
QMF commands: EDIT, DRAW, PRINT, ISPF, TSO, RETRIEVE, INTERACT,
MESSAGE, GET GLOBAL
Computer Exercise: Subqueries and UNION

Defining tables: CREATE, DROP, and ALTER
Modifying tables: UPDATE, DELETE, and INSERT
Views
Controlling access to tables: GRANT and REVOKE
DB2 system catalog tables: SYSTABLES, SYSCOLUMNS, SYSVIEWS
Computer Exercise: Defining Views and Changing Tables

QMF Forms panels: Main, Break, Calc, Columns, Conditions, Detail, Final,
Options, Page
Usage codes
Edit codes
Computer Exercise: Report tailoring with the forms panels

Overview of other QMF facilities
    QMF Charts
    Prompted Query
    Batch QMF
    QMF Table Editor
    QBE
    Programming Interfaces
    Computer Exercise: Batch QMF

Course Objectives
Course description
Home page