Course Description

QMF for SQL Developers

This course: course objectives; course outline;
DB2 curriculum; Topic list; Course list; Home page

Benefits

The student will learn how to utilize the features of Query Management Facility (QMF) on z/OS systems.

Audience

Application developers or end users who need to create and execute SQL statements, format reports, and build procedures.

Prerequisites

The student should have experience with basic SQL.

IBM Materials Required

Classroom access to a set of DB2 and QMF Reference manuals is desirable but not essential.

• QMF Commands
• QMF Panels and navigation
• QMF Objects: queries, procedures, profiles, forms, data, charts, and reports
• Exporting and Importing queries
• Substitution and Global variables
• QMF Procedures
• QMF Forms
• QMF Usage and Edit codes
• QBE (Query By Example)
• Batch QMF
• QMF for Windows

Exercises

There are six machine exercises.