| COURSE : |
Query/400 - (M080) |
| OBJECTIVE : |
Designed for Operations Managers and Supervisors to be proficient in
the use of AS/400 Query. |
| PREREQUISITES : |
-> Having basic knowledge of computing fundamentals, concepts and
environment. |
| METHOD : |
-> Hands-on oriented training with one workstation for each participant
-> Participants to install and implement Query/400 in this workshop
-> Lecturer-assisted and use of computer-generated slides for
presentation
-> Training materials which include notes with key points & graphics
layout |
| DURATION : |
2 days (approximately 14 hours) |
| AUDIENCE : |
-> Operations Managers and Supervisors |
| WHAT YOU WILL LEARN : |
-> Define how to create an AS/400 Query
-> Define options to select, sort, format, peform calculations, specify
output and modify
-> Work with an AS/400 Query |
| COURSE CONTENT : |
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 ?
Working With Queries Display
* Prompt For Query
* Prompt For Library
* Define the Query Display
Specify File Selections
* Define Results Fields
* Select and Sequence Fields
* Select Records
* Select Sort Fields
* Select Collating Sequence
Specify Report Column Formatting
* Select Report Summary Function
* Define Report Breaks
* Select Output Type and Output Form
* Specify Process Option
Copy Queries
* Confirm Delete For Queries
* Run an Existing Query
* Query File
* Delete a Query |
Course Contents - Query/400
