G565 QMF For Programmers

Course Code: G-565
Recommended Duration: 3 Days

Benefits

Students who complete this course will be able to code SQL statements to access DB2 objects using QMF. The student also learns how to use QMF forms to tailor the presentation of results from QMF queries.

Audience

Application programmers who need to work with DB2 data using QMF, and who need to develop applications that incorporate QMF functions.

Prerequisites

The student should have experience in using ISPF/PDF.

Related IBM Materials

This course is drawn from these IBM manuals; access to them in the classroom is desirable but not required:

QMF Reference (current version)
DB2 SQL Reference (current version)

Major Topics Include

Relational data base concepts
DB2 concepts
QMF commands
QMF procedures
SELECT, UPDATE, DELETE, INSERT
Data aggregation
Joined and nested queries
Creating DB2 tables
DB2 objects
DB2 system catalog tables
QMF forms
Report tailoring
Batch QMF

Exercises

There are nine machine exercises and one optional machine exercise.

Special Note

This course's content overlaps heavily with the material in course G-550 (SQL Coding Workshop).

Course Description

QMF For Programmers