Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Db2 QMF: Query Management Facility

Home

distance-learning center

Application of Classic Teaching Models Mobile Classrooms

Professional Distance-learning

IT Training Services



MFRDB06

Db2 QMF: Query Management Facility
DURATION: 3 days

FEE: $1,485

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Business Professional
  • Support Personnel
  • Programmer
  • Database Administrator
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. Db2 QMF Facilities and Queries
      • Examine the concepts and terminology of a RDMS.
      • Use a human resource system to produce sample reports.
      • Invoke and customize QMF.
      • Set the defaults for the query type, log dataset names, and printer information.
    2. Saving Queries and Temporary Storage Areas
      • Execute queries and display reports.
      • Run a series of queries by drawing requests.
      • Modify the queries and convert to SQL.
    3. Db2/SQL and QBE
      • Examine and use QMF commands.
      • Run commands to save the queries, reports, and data into sequential datasets.
      • Create and execute interactive scripts to run reports.
      • Execute batch QMF for printing reports.
    4. Detailed Report Formatting
      • Display and modify a report.
      • Modify the form to include additional heading and footings.
      • Modify the size of column.
      • Change column headings.
      • Use report generation options and execute scripts.
      • Modify the form to include break logic, statistics, and detail/summary reports.
    5. Table Editor
      • Use the Table Editor to add, delete, and change rows in a table.
    6. Advanced Topics
      • Identify and resolve run-time errors.
      • Distinguishing columns with the same name UNION.
      • Nesting SQL statements.
      • Replacing null values in a report with other values.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.