Loading Course Schedule...
PT0122
Training Summary
This class examines all aspects of the IBM System i (AS/400) Query/400 product. The audience for the class is both end users and System i (AS/400) technical staff.
Prerequisites
There are no prerequisites for this course.
Duration
1 Day/Lecture & Lab
Audience
This course is designed for end users and System i (AS/400) technical staff.
Course Topics
Query/400 Introduction
- Physical and Logical Files
- Relational Database Systems
- 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
- Performance Considerations