DB2 for z/OS: Using QMF

Objectives
On successful completion of this course, attendees will be able to:

• list the objects that comprise a relational database
• describe the tabular format of data and the relationships between tables
• code SQL statements to report from, and maintain data in DB2 tables
• build queries using QMF
• use forms to tailor reports from query results
• build QMF procedures.

Who Should Attend
All DB2 users.
Prerequisites
A familiarity with TSO and ISPF would be useful but is not mandatory.
Duration
2 days

Course Code
DQMF
Contents
Introduction to QMF
QMF basics; how QMF works; temporary storage of objects; queries, data, reports and charts; QMF application support facilities.


QMF fundamentals
Starting the QMF session; using the 'help'; the SHOW command; retrieving commands; ending the QMF session.


Using Prompted Query
Prompted Query basics; Prompted Query panels; getting help for Prompted Query; Prompted Query commands.


Using SQL for queries
Basic SQL syntax; creating an SQL Query; executing a query; modifying a query; selection criteria; using derived and calculated values.


General query tasks
Query reports; scrolling the report; saving the query; listing and displaying saved queries; converting queries.


Format reports
Formatting a report; control columns and usage codes; changing a Format; getting help with formatting.


Charts
Displaying reports as charts; using form panels to create charts; changing chart type; saving a chart.


Table Editor
Using Table Editor to copy a table; adding, changing and deleting rows in a table.


Advanced topics
Creating queries and forms for use by others; creating procedures; creating and maintaining tables; exporting and importing objects; using the database object list.


Hands-on exercises
All course sections are accompanied by hands-on exercises to reinforce understanding of the topics covered.