iSeries Query/400: Construction and Management

Duration

Overview

Audience

Prerequisites

Objectives

• After completing this course, the student will be able 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.
• Identify useful tips and techniques to use with Query/400.

Course Content

Unit 1 iSERIES QUERY/400: CONSTRUCTION AND MANAGEMENT PRETEST

Unit 2 CREATING ADVANCED QUERIES

• 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

Unit 3 VIEWING A QUERY FROM A SPOOL FILE

• Work with Query Spooled Files

Unit 4 MANAGING QUERIES

• 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

Unit 5 USING THE DATAFILE UTILITY WITH QUERIES

• Data File Utility
• Add, Change, Delete records in a Database
• Data Description Source

Unit 6 TIPS ON USING QUERIES

Unit 7 iSERIES QUERY/400: CONSTRUCTION AND MANAGEMENT MASTERY TEST