Loading Course Schedule...
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.
Experience using TSO and ISPF are helpful but not required.
3 Days/Lecture & Lab
This course is designed for application developers or end users who need to produce formatted reports from DB2 tables, using the Query Management Facility.
QMF basics::SQL SELECT statements::SQL functions and expressions::QMF control break reports::QMF free-form reports::QMF summary reports::Appendix SQL joins