Course Description (By Curriculum)
3 to 5 hours
Personnel requiring an intermediate knowledge to create reports with the Query facility
Completion of the iSeries Query/400 Introduction and Fundamentals course and knowledge of iSeries concepts
After completing this course, the student will be able to identify how to:
• Create queries using most of the Query features
• Display Query reports from a Spool File
• Change, copy, delete, display, and print existing Queries
• Use Data File Utility (DFU) with Query/400
• Use some tips and techniques with Query/400
Construction of a Query to Produce a List of Company Products
Define the Query
Define Result Fields
Select and Sequence Fields
Select Sort Fields
Specify Report Column Heading
Select Report Summary Functions
Define Report Breaks
Format Report Breaks
Select Output Type and Output Form
Work with Query Spooled Files
Work with Queries Screens
Creating a Query
Changing an Existing Query
Copying an Existing Query
Deleting a Query
Displaying a Query
Printing a Query Definition
Five Methods of Running a Query
Working with Multiple Queries at the Same Time
Data File Utility
Add, Change, Delete Records in a Database
Data Description Source
