iSeries Query/400: Introduction and Fundamentals

Duration

3 to 5 hours

Overview

Audience

Personnel requiring an intermediate knowledge about creating reports with the Query facility.

Prerequisites

Knowledge of iSeries concepts.

Objectives

After completing this course, the student will be able to:
• Define the concepts of Query/400
• Identify how to define iSeries files
• Define Database file concepts
• Identify the files to use in Query/400
• Identify how to join files in a Query report
• Identify how to create a basic Query report

Course Content

iSeries Query/400: Introduction and Fundamentals Pretest

What is Query?

Query/400
Report Formats
Query Definitions

Database Concepts

Physical Files
Logical Files
Records, Fields
Normalization
Primary Key

How Files are Defined to the System

Data Description Specifications
Record Format Name
Field Name, Length, and Type

Description of the Example Database

An Example Database (Order Entry System) Includes:
• Physical Files
• Customer Master Files
• Product Master Files
• Customer Order Files
• Employee File

Creating a Query Report Program

Introduction to the Use of Query
Signing on to Query
Simulation of Using Query

Joining Files

Join Operation
Primary File
Secondary File

Creating a Basic Query

Construction of a Query to Produce a Report From a Customer Master File

iSeries Query/400: Introduction and Fundamentals Mastery Test