Datatrain
Partners
Login
  Username
  Password
  Partner Login
 
Forgot Password?
Register Now!
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » iSeries Curriculum » iSeries Query Series

Query for Users

Duration
10 hours

Overview

Description

The Query For Users course describes the Query/400, the report writer that comes with the iSeries. It explains how the Query/400 can help users and programmers create simple reports without having to programmatically develop them. It also shows how to access information stored in DB2/400 tables.

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

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

Joining Files

Join Operation

Primary File

Secondary File

Creating a Query Part 1

Introduction to the Use of Query

Signing on to Query

Simulation of Using Query

Creating a Query Part 2

Introduction to the Use of Query

Signing on to Query

Simulation of Using Query

Viewing a Query from a Spool File

Work with Query Spooled Files

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

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

Creating a Query Report Program

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

Query for Users Mastery Test

Course Catalog » iSeries Curriculum » iSeries Query Series
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM