iSeries (AS/400) Query for Advanced Users
Course Code: AQY2
AS/400 Query for Advanced Users is a self-paced, audio based course providing
comprehensive, practical training in the advanced functions of Query/400.
Upon completion you'll be able to:
with commands, menu options, or OfficeVision/400.
CL commands from a command line.
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.
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
Merge data from
a query with an OfficeVision/400 document.
calendaring functions to schedule queries.
Use Query/400 to
or national language sorts.
| Advanced Query/400 Concepts
Outputting to a Data Base File
Joining Two or More Files
Querying and Creating File Members
WRKQRY (Work with Queries)
TRQRY (Start Query)
RUNQRY (Run Query)
DLTQRY (Delete Query)
SBMJOB (Submit Job)
Delaying a Query via a CL Program
| Merging Queries with Documents
Column List Merge
Dependent Column List Merge
DATE, TIME, and TIMESTAMP Data
Extracting Units of Time
Conversion to Character Data
Variations in Formats
Using the Current Date and Time
| Record Selection|
LIKE and NLIKE
LIST and NLIST
IS NULL and ISNOT NULL
Break Level Selection
Special Edit Words
Scheduling Queries with OfficeVision/400
Formatting Summary Values
Both data processing and non-data processing personnel who require more
information from AS/400 data bases.
AS/400 Workstation Operations or keyboard familiarity
AS/400 Query for Users
Self Study Interactive
11 Audio CD's
| Time Required |
Approximately 12 Hours