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
$595




Description
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
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 iSeries.
Prerequisites
iSeries Workstation Operations
Format
Self-Instructional
Materials
Six Audio CDs
Student Text
Workbook
Interactive Media
Time Required
Approximately 10 Hours


iSeries Query for Users (AQY1)
Author: ATS
$595



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