QMF for SQL Developers

Course Title: QMF for SQL Developers

Course#: DB12T

Duration: 1.5 days

Overview:

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

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
• Batch QMF

Exercises:

There are five machine exercises.

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.