Course Description (By Curriculum)
3 to 5 hours
Personnel requiring an intermediate knowledge about creating reports with the Query facility
Knowledge of iSeries concepts
After completing this course, the student will be able to:
• Define the concepts of Query/400
• Identify how to define iSeries files
• Define Database file concepts
• Identify the files to use in Query/400
• Identify how to join files in a Query report
• Identify how to create a basic Query report
Query/400
Report Formats
Query Definitions
Physical Files
Logical Files
Records, Fields
Normalization
Primary Key
Data Description Specifications
Record Format Name
Field Name, Length, and Type
An Example Database (Order Entry System) Includes:
- Physical Files
- Customer Master Files
- Product Master Files
- Customer Order Files
- Employee File
Introduction to the Use of Query
Signing on to Query
Simulation of Using Query
Join Operation
Primary File
Secondary File
Construction of a Query to Produce a Report From a Customer Master File
