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