Course description: DB2 QMF on z/OS Workshop - Instructor Led Online

This is the Instructor Led Online version of clasroom course DB2 QMF on z/OS Workshop (CV740)

This is an online course. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.

This course builds on previously acquired knowledge of the SQL language. You will learn how to use IBM's Query Management Facility (QMF) to access data stored in a database manager, as well as QMF's very powerful report formatting capabilities to produce tailored reports. You learn to direct QMF's activities using the QMF Command Language, the ins and outs of writing QMF Procedures (PROCs), and enhancing your reports and publishing them on the Web.

View this course in other countries

Training Paths that reference this course are:

• Data Warehousing Products for z/OS
• Data Warehouse Products
• QMF

Back to top

IBM Education Advantage Program eligibility:

• Yes - IBM Education Pack - Online Account

Back to top

This intermediate course is for avanced end users, application designers, programmers, QMF support personnel, and end-users that have used QMF but have not had formal training in QMF.

Back to top

You should have:

• DB2 SQL Workshop (CE12) CE120) or
• equivalent SQL knowledge and experience.

Back to top

• Execute SQL queries from QMF
• Save QMF objects (queries, forms and procs)
• Have QMF create table descriptions
• Use QMF forms to tailor reports
• Use QMF commands and write QMF command procedures
• Publish QMF reports to the Web

Back to top

QMF Overview

• Form 1: Simple Reports
• Form 2: Enhancing Simple Reports
• Form 3: Advanced Report Formatting
• QMF Commands
• QMF Procedures
• Publishing Reports to the Web

Optional Topics:

• Prompted Query Language
• Table Editor
• QMF Application Support
• Charting

Back to top