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.