QMF for SQL Developers

Course Number:  609-TF
Recommended Duration:  2 days

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

Course Overview
This course is for experienced SQL coders who need to know how to use QMF facilities to format SQL requests.

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

Prerequisites
The student should have experience with basic SQL.

Topics

• 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