Duration
2 days
Course Description
- Designed for users to be proficient in the use of AS/400 Query
- Define how to create an AS/400 Query
- Define options to select, sort, format, perform calculations, specify output and modify
- Understand the basics of AS/400 database, including logical files and keyed access paths
- Decrease the impact Queries have on other users (via Batch or Logical Files)
- Gain a more detailed understanding of some of the advanced functions of Query/400 such as
- substrings.
Audience
Operations Managers and Supervisors
Prerequisites
Having basic knowledge of computing fundamentals, concepts and environment.
Module 1: Query/400
- Purpose of Query/400
- How Data is Stored in Your System
- What is a Library?
- What is a Query Definition?
- How to Access Query/400?
Module 2: Working With Queries Display
- Prompt for Query
- Prompt for Library
- Define the Query Display
Module 3: Specify File Selections
- Define Results Fields
- Select and Sequence Fields
- Select Records
- Select Sort Fields
- Select Collating Sequence
Module 4: Specify Report Column Formatting
- Select Report Summary Function
- Define Report Breaks
- Select Output Type and Output Form
- Specify Process Option
Module 5: Copy Queries
- Confirm Delete For Queries
- Run an Existing Query
- Query File
- Delete a Query
Module 6: Additional Advance Query/400
- Tables, Files, Libraries
- AS/400 Jobs – Queues, Subsystems
- Batch vs. Interactive
- Working with Batch Jobs
- Database Overview
- Physical Files
- Logical Files
- Finding out about existing Files
- Creating Your Own Logical Files
- Query Optimization
- Access Plans
- Tips Techniques
- Joins
- Substrings
Programme scope, delivery arrangements and suitability are confirmed during enquiry.