iSeries (AS/400) Query for Advanced Users

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.

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 AS/400 data bases.

Prerequisites
AS/400 Workstation Operations or keyboard familiarity
AS/400 Query for Users

Format
Self Study Interactive

Materials
11 Audio CD's
Student Text
Workbook
Interactive Software Time Required
Approximately 12 Hours

Price
£ 475

back


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 AS/400 data bases. Prerequisites AS/400 Workstation Operations or keyboard familiarity AS/400 Query for Users	Format Self Study Interactive Materials 11 Audio CD's Student Text Workbook Interactive Software	Time Required Approximately 12 Hours Price £ 475