iSeries (AS/400) Basic Query

Introduction

This course in intended for end users and support staff who need to create, modify and run query reports. The course covers the basics of creating new query definitions and modifying existing queries. It takes users step by step through the options to create and run a query in easy to understand terms. The course is very much "hands on" and delegates have plenty of opportunity to get to grips with the fundamentals of writing queries.

Who should attend

This course is for end users and support staff of Query to help them harness the power of Query to develop queries for reporting and enquiries.

Pre-requisites

There are no prerequisites for this practical course. Basic keyboard skills and a knowledge of the applications to be queried will be helpful to enable users to complete the many hands on exercises.

For courses run in house, the exercises can be customised to use your own database and applications. A nominal charge will be made for this service.

Course content

• Introduction to Query
• Explain Query and database file terminology
• How Queries process in batch and interactive environments
• Use of function keys within Query
• Starting Query
• Exit, Save and Run a Query definition
• Examples of storing Queries in libraries
• How to select the file and library that you wish to report on
• How to select and sequence the fields required in the report
• How to select which records you require in the report
• Detail the different record tests
• Examples of the different record tests
• Using the And and Or options when selecting records
• How to sort the list of records in the report into a logical sequence
• How to define report breaks
• Defining sub totals and final totals
• How to hide sub totals and final totals
• Output a Query to print
• Format the printed output
• Selecting detail and summary output
• Selecting report column formatting
• Formatting numeric and date fields
• How to reduce column heading lengths
• How to change existing Queries
• Query design checklist
• Manipulate printed output using the WRKSPLF command

Materials

A course manual with supporting documentation is provided. The course is based around the practical use of query to demonstrate all of the major features of query for users.

Follow on course : we reccomend that after a suitable period of time of attending this course ( e.g. 3 to 6 months hands on experience ) then delegates may want to enhance the knowledge thay have gained by attending the Advanced Query course (ISQRA)

Schedule