IBM i Query Workshop for Technical Staff and End Users

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

Related Scheduled Courses