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 Advanced Users

iSeries Query for Advanced Users (AQY2)
Author: ATS
$695




Description
iSeries Query for Advanced Users is a self-paced, audio-cassette course providing comprehensive, practical training in the advanced functions of Query/400.

Upon completion you'll be able to:

  • Access Query/400 with commands, menu options, or OfficeVision/400.

  • Run query-related CL commands from a command line.

  • Obtain various forms of information about query objects using CL commands and outfiles.

  • Identify and query physical and logical files.

  • Access file members and create data base files using Query/400.

  • Query and join two or more files.

  • Display and print information about fields contained in data base files.

  • Use variable length, null-capable DATE, TIME, and TIMESTAMP fields in a query.

  • Perform specialized functions and arithmetic on DATE, TIME, and TIMESTAMP data type fields.

  • Calculate the difference between two dates or times.

  • Convert any numeric or alphanumeric date field into a DATE data type field.

  • Use advanced query techniques to convert numeric data to alphanumeric, and edit, concatenate, and subdivide fields.

  • Merge data from a query with an OfficeVision/400 document.

  • Use OfficeVision/400 calendaring functions to schedule queries.

  • Use Query/400 to print labels.

  • Perform hexadecimal or national language sorts.

Advanced Query/400 Concepts
Outputting to a Data Base File
Joining Two or More Files
   Matched Records
   Unmatched Records
Querying and Creating File Members
CL Commands
Prompting Commands
WRKQRY (Work with Queries)
TRQRY (Start Query)
GO QUERY
GO CMDQRY
RUNQRY (Run Query)
DLTQRY (Delete Query)
SBMJOB (Submit Job)
Delaying a Query via a CL Program
Merging Queries with Documents
Direct Merge
Column List Merge
Multicopy Merge
Dependent Column List Merge
DATE, TIME, and TIMESTAMP Data
Extracting Units of Time
Conversion to Character Data
Variations in Formats
Arithmetic Operations
Using the Current Date and Time
Record Selection
LIKE and NLIKE
LIST and NLIST
IS NULL and ISNOT NULL
Break Level Selection
Advanced Topics
SUBSTR Function
DIGITS Function
Concatenate Function
CHAR Function
Break Text
Special Edit Words
Scheduling Queries with OfficeVision/400
Formatting Summary Values

Audience
Both data processing and non-data processing personnel who require more information from iSeries data bases.
Prerequisites
iSeries Workstation Operations
iSeries Query for Users
OfficeVision/400ÐBasic Word Processing
Format
Self-Instructional Audio-Cassettes
Materials
Six Audio-Cassettes
Student Text
Workbook
Interactive Media
Time Required
Approximately 12 Hours


iSeries Query for Advanced Users (AQY2)
Author: ATS
$695



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