Name: QMF Workshop
Course Code: CI075
Duration: 3
Scheduled Dates for CI075
The concepts of DB2 are briefly presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data. The students will go through several guided, hands-on, practice sessions giving them an opportunity to use QMF to build custom reports from DB2 data using the extensive powers of the QMF FORMs panels. The students will also use several other QMF facilities such as Help, Retrieve/?, Save/Display, Export/Import, Prompted and SQL Query modes, PROCs.
Target Audience
End-Users and Information Technology personnel who need use the Query management facility (QMF) to build reports from DB2 data.
Key Topics
- 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
Required Skills/Experience
- At least six months of TSO/ISPF experience is recommended.
- No previous database experience is needed.
Fee: $1,050.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
