AS/400 Query for Advanced Users (Audio Training)

Course Description:
AS/400 Query for Advanced Users is a self-paced audiocassette course providing comprehensive, practical training in advanced functions of Query/400.

Time required: Approximately 12 hours

Upon completion of this audio program, you will be able to:
   • Access Query/400 with commands, menu options, or OfficeVision/400
   • Run query-related CL commands from a command line
   • Use CL commands and outfiles to obtain various forms of information about query objects
   • Identify and query physical and logical files
   • Use Query/400 to access file members and create database files
   • Query and join two or more files
   • Display and print information about fields contained in database files
   • Use variable-length, null-capable DATE, TIME, and TIMESTAMP fields in a query
   • Perform arithmetic and specialized functions 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
   • Edit, concatenate, and subdivide fields
   • Merge data from a query with an OfficeVision/400 document
   • Use OfficeVision/400 calendar functions to schedule queries
   • Use Query/400 to print labels
   • Perform hexadecimal or national language sorts

Audience: Users, Operators, Programmers

Prerequisites: AS/400 Workstation Operations AS/400 Query for Users OfficeVision/400: Basic Word Processing

Course Outline:
   Advanced Query/400 Concepts
     Outputting to a Database File
     Joining Two or More Files
         Matched Records
        Unmatched Records
     Querying and Creating File Members
   CL Commands
     Prompting Commands
     WRKQRY (Work with Queries)
     STRQRY (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

Course Details:

Level:	Advanced
Subject:	Query
Length:	12 hrs.
Materials:	Six Audiocassettes; Student Text; Workbook; Interactive media
Publisher:	ATS
Publish Date:	June 1998