METHOD :
- Hands-on oriented training with one workstation for each participant.
- Training materials which include notes with key points and graphics layout.
- Participants to install and implement Query/400 in this workshop
- Lecturer-assisted and use of computer-generated slides for presentation
DURATION : 2 days ( approximately 14 hours )
COURSE CONTENT :
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
