iSeries Query/400: Construction and Management

Duration

3 to 5 hours

Overview

Audience

Personnel requiring an intermediate knowledge to create reports with the Query facility.

Prerequisites

Completion of the iSeries Query/400 Introduction and Fundamentals course and knowledge of iSeries concepts.

Objectives

After completing this course, the student will be able to identify how to:
• Create queries using most of the Query features
• Display Query reports from a Spool File
• Change, copy, delete, display, and print existing Queries
• Use Data File Utility (DFU) with Query/400
• Use some tips and techniques with Query/400

Course Content

iSeries Query/400: Construction and Management Pretest

Creating Advanced Queries

Construction of a Query to Produce a List of Company Products
Define the Query
Define Result Fields
Select and Sequence Fields
Select Sort Fields
Specify Report Column Heading
Select Report Summary Functions
Define Report Breaks
Format Report Breaks
Select Output Type and Output Form

Viewing a Query from a Spool File

Work with Query Spooled Files

Managing Queries

Work with Queries Screens
Creating a Query
Changing an Existing Query
Copying an Existing Query
Deleting a Query
Displaying a Query
Printing a Query Definition
Five Methods of Running a Query
Working with Multiple Queries at the Same Time

Using the Data File Utility with Queries

Data File Utility
Add, Change, Delete Records in a Database
Data Description Source

Tips on Using Queries

iSeries Query/400: Construction and Management Mastery Test