SQL Query Building in DB2/QMF
- Recommended Duration:
- 2 Days
- Version
- DB2 Version 5. This course is suitable for those shops still running DB2 Version 3 or 4.
- Benefits
- Students who complete this course will be able to code SQL statements to access DB2 objects using QMF.
- Audience
- Technical personnel who need to retrieve data from DB2 Data Bases.
- Prerequisites
- The student should have at least 3 months experience using ISPF/PDF (especially the text editor) and should be able to code JCL to run simple batch jobs or have completed the "Introduction to TSO/ISPF" and "MVS and OS/390 JCL and Utilities" courses within the last 12 months.
- Major Topics
-
- DB2 Overview
- Relational data base concepts
- SELECT
- QMF usage
- DB2 sample data bases
- Built-in functions
- Joined queries
- UNION
- Creating DB2 tables
- Views
- DB2 system catalog tables
- Common problems
- Exercises
- There are six machine exercises.