QMF Concepts, Facilities & Usage

 LENGTH OF COURSE:
2 Days

DESCRIPTION: This course is designed to be a comprehensive introduction to the IBM Query Management Facility (QMF) product. The students will be introduced to the concept of relational databases and how to use QMF to view and manipulate data. The course includes an easy to use guide that walks the student through QMF.

PREREQUISITES: Some knowledge of computers and terminology.

INSTRUCTION TECHNIQUES: A combination of Lecture, Exercises, and Labs (when/where available).

AUDIENCE

Application Users, Developers, Managers, and Technicians that need to access and format DB2 data. The course will concentrate on how to use the QMF facility and not the detailed technical aspects of the product.
KEY HIGHLIGHTS:
  • Understand QMF Commands and Panels
  • Manipulate the QMF user profile
  • Manage QMF sessions
  • Use Query By Example (QBE)
  • Use Prompted Query to access data
  • Select Singleton and Joined Tables
  • Write Expressions
  • Build Row Condition Statements
  • Save and Retrieve Queries
  • Interrupt Queries
  • Build Procedures, Save, and Execute
  • Use SQL Queries
  • Build complex queries in QMF
  • Use Forms to manipulate data/reports
  • Display Reports and Modify their content
  • How to use the QMF Table Editor


  • Add, Change, and Insert Rows with Table Editor
  • Understand how QMF as a product works
  • Use the DRAW Feature of the product
  • Build Scripts using QMF
  • Using QMF to assist in application development
  • Use QMF Advanced Features


FROM OUR STUDENT EVALUATIONS...
"The instructor was very knowledgeable about the subject. He also presented the information with enthusiasm which made the course more interesting than some other classes I've taken."

Annette Conlon

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.