Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Query Management Facility (QMF) for End-Users
Overview

The concepts of DB2 are briefly presented and discussed.

The Structured Query Language (SQL) is presented as the means to access DB2 data.

Several guided, hands-on, practice sessions give each attendee an opportunity to use QMF to build "custom:" reports from DB2 data using the extensive powers of the QMF FORMs panels.

Use several other QMF facilities such as Help, Retrieve/"?", Save/Display, Export/Import, Prompted and SQL Query modes, PROCs.

LEARNING OBJECTIVES

As a result of this class, the attendee will be able to -

  • Explain DB2 concepts, terminology and components
  • SELECT rows of data from DB2 tables using the WHERE clause to retrieve specific rows
  • Format QMF Reports by modifying the QMF FORM
  • Use several QMF Commands
  • LIST, RUN, SAVE/DISPLAY, EXPORT/IMPORT, SHOW
  • Build Queries with the PROMPTED MODE
  • JOIN tables together to get information from each
  • Use the SQL SubSelect feature of SQL
  • Build QMF Reports "beyond the basics" using FORM.MAIN, FORM.PAGE, FORM.COLUMNS, FORM.FINAL, FORM.BREAK1-6, and the (form) LAYOUT command
  • Build QMF Reports using "additional FORM features" such as FORM.OPTIONS, FORM.DETAIL, FORM.CALC, FORM.COND
  • Build QMF PROCedures to Run a series of QMF commands allowing for user input of Data and SQL as VARIABLES
  • Use the QMF TABLE EDIT facility to SEARCH through a table and to make CHANGES to a table
  • Build SQL SELECT, INSERT and UPDATE statements using the QMF DRAW command
Audience

End-Users and Information Technology personnel who need use the Query Management Facility (QMF) to build reports from DB2 data.

Prerequisites

  • At least six months of TSO/ISPF experience is recommended.
  • No previous database experience is needed.
Course duration

3 days

Course outline

DAY 1
 
  1. DB2 Concepts and Terminology
  2. The SELECT Statement
  3. QMF Basics
  4. QMF PROMPTED Query - Introduction
  5. Join and SubSelect
  6. QMF PROMOTED Join 1
  7. QMF PROMOTED Join 2
DAY 2
 
  1. QMF Report Formatting 1
  2. QMF Report Formatting 2
  3. QMF Forms Show
  4. QMF Export Import
  5. QMF Form Detail
DAY 3
 
  1. QMF PROCs - Multiple QMF Commands
  2. QMF PROCs - VARIABLES as Data and as SQL components
  3. QMF TABLE EDITOR SEARCH
  4. QMF TABLE EDITOR CHANGE
  5. QMF DRAW

Appendices
 
  1. Sample Tables
  2. Bibliography
  3. QMF EDIT and USAGE Codes
  4. QMF Commands
  5. REXX LOGIC in QMF Procs
  6. QMF Overview
  7. QMF PROC with variables for SQL


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy