Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More DB2

Related Courses

SQL Query Building in DB2/QMF

Recommended Duration:
2 Days
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 "z/OS 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.