iSeries Query/400: Introduction and Fundamentals

Duration

Overview

Audience

Prerequisites

Objectives

• Describe the concepts of Query/400.
• Identify how to define iSeries files.
• Describe Database file concepts.
• Identify files to use in Query/400.
• Describe how to join files in a Query report.
• Create a basic Query report.

Course Content

Unit 1 iSERIES QUERY/400: INTRODUCTION AND FUNDAMENTALS PRETEST

Unit 2 WHAT IS QUERY?

• Query/400
• Report Formats
• Query Definitions

Unit 3 DATABASE CONCEPTS

• Physical Files
• Logical Files
• Records, Fields
• Normalization
• Primary Key

Unit 4 HOW FILES ARE DEFINED TO THE SYSTEM

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

Unit 5 DESCRIPTION OF THE EXAMPLE DATABASE

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

Unit 6 CREATING A QUERY REPORT PROGRAM

• Introduction to the use of Query
• Signing on to Query
• Simulation of using Query

Unit 7 JOINING FILES

• Join Operation
• Primary File
• Secondary File

Unit 8 CREATING A BASIC QUERY

• Construction of a Query to Produce a Report from a Customer Master File

Unit 9 iSERIES QUERY/400: INTRODUCTION AND FUNDAMENTALS MASTERY TEST