Query for Users

Course Code: AQY1

Description

AS/400 Query for Users is a self-paced, multimedia course course providing comprehensive, practical training in the many facets of Query and the fundamentals of report writing.

Upon completion you'll be able to:

Select a specific file to be queried.
Perform record and field selection, as well as record and field sequencing.
Format the report using system-defined and user-defined specifications.
Create report breaks based on the value of a field.
Produce detail and summary reports.
Create a simple query that joins two files.
Create and use result fields.

Basic AS/400 File Concepts
Query Processing Cycle
Formatting Reports

Report and Column Headings
Field Edit Codes
Edit Words
Selecting Fields
Sequencing the Report Columns
Omitting Fields
Footers
User-Defined Headings
Data Selection and Sorting
Selecting Specific Records
Sorting Report Information
Computation Fields
Defining Computation Fields
Add, Subtract, Multiply, and Divide
Computation Field Headings
Batch Processing
Summary Reports
Totals and Subtotals
Averaging Functions
Report Breaks
Managing and Printing Reports
Executing Query Programs
Displaying Reports on the Workstation
Changing and Deleting Query Programs
Displaying the Layout of a Query
File Chaining
Query Program Maintenance
Renaming Query Programs
Copying Query Programs
Security
Merging Query within a Document
Direct Merge
Help Support

Audience
Both data processing and non-data processing personnel who require more information from the AS/400.
Prerequisites
AS/400 Workstation Operations
Format
Self-Instructional
Materials
Six Audio CDs
Student Text
Workbook
Interactive Media
Time Required
Approximately 10 Hours

Copyright © Vermillion Associates, 2005