AS/400 Links Partner with Rochester Institute Contact Us
Training Catalog Free Downloads Privacy / Usage

IBMi and AS400 Training
HOME >> Training Catalog >> iSeries Query for Users

iSeries Query for Users (AQY1)
Author: ATS

iSeries Query for Users is a self-paced, audio CD 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 iSeries File Concepts
Query Processing Cycle
Formatting Reports

Report and Column Headings
Field Edit Codes
Edit Words
Selecting Fields
Sequencing the Report Columns
Omitting Fields
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
Merging Query within a Document
Direct Merge
Help Support

Both data processing and non-data processing personnel who require more information from the iSeries.
iSeries Workstation Operations
Six Audio CDs
Student Text
Interactive Media
Time Required
Approximately 10 Hours

iSeries Query for Users (AQY1)
Author: ATS

Rochester Training
     RPG Skills Accelerator - Volume 2
     RPG Skills Accelerator
     e-RPG Powertools – Stone on CGIDEV2
     WebFacing Now! WAS-Express Edition
     JDBC and Record Level Access
with IBM AS/400 Toolbox for Java
     Turbo Query/400
     XML Web Services for RPG Programmers
     RPG Modernization with WDSC (from III to IV to /Free)
     Microsoft .NET for RPG Programmers (Visual Basic Version)
     Microsoft .NET for RPG Programmers (C# Version)
     iSeries Navigator for Programmers (V5R3 Edition)
     SQL for RPG Programmers
     Subprocedures for RPG Programmers
     RPG Web Skills Accelerator
     WDSC for RPG Programmers (Version 7)
     WDSC for RPG Programmers (Version 6)
     Microsoft Word with the iSeries
     Microsoft Excel with the iSeries
Operations Training
     iSeries Advanced System Operations
     iSeries System Operations
     iSeries Startup Operations
     iSeries Security
     iSeries Work Management
User Training
     iSeries Query for Users
     iSeries Query for Advanced Users
     iSeries RPG/400 Programming
     iSeries RPG/400 Interactive Programming
     iSeries RPG/400 Advanced RPG Programming
     iSeries RPG/400 Subfile Programming
     iSeries RPG IV Programming
     iSeries Data Base Administration I
     iSeries Data Base Administration II
     iSeries Control Language Programming
     iSeries CL and Programming Techniques
     iSeries SQL/400
     iSeries Advanced COBOL/400 Programming
     iSeries Interactive COBOL/400 Programming
     iSeries COBOL/400 Programming
     iSeries COBOL/400 Subfile Programming
     iSeries Program Development
Training Bundles
     iSeries Operations & Administration Bundle
     Microsoft Word and Excel with the iSeries Bundle
     RPG Skills Accelerator & RPG Web Skills Accelerator
     RPG Basics and Beyond (training bundle)
     RPG Skills Accelerator & RPG Skills Accelerator - Volume 2