Loading Course Schedule...
PT1813
Summary
In this course, the student will learn how to execute SQL SELECT queries using numerous functions and expressions and format columnar, free-form and matrix reports using the QMF screens.
Prerequisites
Experience using TSO and ISPF are helpful but not required.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for application developers or end users who need to produce formatted reports from DB2 tables, using the Query Management Facility.
Topics
QMF basics::SQL SELECT statements::SQL functions and expressions::QMF control break reports::QMF free-form reports::QMF summary reports::Appendix SQL joins