EIEIOTECHNOVATION
← Training programmes

EIEIO / AUTOMATION & EMERGING TECHNOLOGY

for IBM System i

Course outline

QUERY4001 day

Duration

1 day

Audience

This course is designed for end users and System i (AS/400) technical staff.

Prerequisite

None

Objectives

After completion of this course, the participants should have better understanding about:

Introduction to System i Libraries and Objects

Introduction to Physical File and Logical File

Introduction to Query/400

Creating report using Query/400

Topics:

Physical and Logical Files

System i Libraries and Objects

Specifying Query File Selections

Selecting and Sequencing Fields

Selecting Records

Sort Fields

Column Formatting

Summary Functions

Defining Report Breaks

Selecting Output Types

Defining Result Fields

Joining Files

Programme scope, delivery arrangements and suitability are confirmed during enquiry.