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