iSeries (AS/400) Query for Advanced Users

Course Code: AQY2

Description
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:

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.