iSeries (AS/400) Query for Users
Now Released on Audio CD
Course Code: AQY1
AS/400 Query for Users is a self-paced, audio driven course providing comprehensive,
practical training in the many facets of Query and the fundamentals of report
Upon completion you'll be able to:
Select a specific
file to be queried.
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.
and summary reports.
Create a simple
query that joins two files.
Create and use
| Basic AS/400 File Concepts
Query Processing Cycle
Report and Column Headings
Field Edit Codes
Sequencing the Report Columns
| Data Selection and Sorting
Selecting Specific Records
Sorting Report Information
Defining Computation Fields
Add, Subtract, Multiply, and Divide
Computation Field Headings
Totals and Subtotals
| Managing and Printing Reports|
Executing Query Programs
Displaying Reports on the Workstation
Changing and Deleting Query Programs
Displaying the Layout of a Query
Query Program Maintenance
Renaming Query Programs
Copying Query Programs
Merging Query within a Document
Both data processing and non-data processing personnel who require more
information from the AS/400 using the Query tool.
AS/400 Workstation Operations or keyboard familiarity
Self Study Interactive
11 Audio CD's
Approximately 10 Hours