Basic QMF for Workstations

During this course, you will develop QMF queries using Structured Query language (SQL). The class provides basic coverage of the capabilities and uses of QMF, with a focus on learning the Structured Query Language (SQL) and some of the reports that can be produced using QMF forms. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops.
No previous experience in SQL is required. Ability to use TSO and ISPF is recommended.
2 Days/Lecture & Lab
Business professionals who are exposed to or are required to perform the activities associated with data stored in a Db2 relational database.
  • Relational Database Concepts
  • QMF for Workstation Overview
  • Basic Data Manipulation
  • QMF Forms (Formatting)
  • Intermediate Data Manipulation
  • Reports with Control Breaks
  • Built-In Functions

Related Scheduled Courses