Custom Search
Provided by: Interskill Learning

5.1 iSeries Query400 Introduction and Fundamentals

IBM Systems

Interskill Learning
Training Provided by Interskill Learning This is course 1 of 2 in the iSeries Query Series. The course is delivered via e-Learning. It can be accessed online, at any time, place or location with internet access, or delivered through your own internal LMS (if applicable). The course is available as part of the iSeries Query Series, or in a Mainframe Bundle, comprising of the 100 most popular mainframe e-Learning titles.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Interskill Learning for more information
Course Level:introductory
Duration:5 hours
Training Presented in:English
5.1 iSeries Query400 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

About The Training Provider: Interskill Learning
Interskill Learning - Interskill Learning is a worldwide leader in the provision of e-learning, delivering reliable, quality learning solutions since 1991 to over 1500 organisations. With 1000s of titles to chose from in mainframe, desktop, IT and business subject areas, Interskill offers a comprehensive training solution for your entire workforce, regardless of their department, location or language. With three...
Do you teach iseries ?
tcw11-gfc-v396M-10/25/09-11:18:43-()[A]-[A]-[A] -23:12:25