iSeries (AS/400) Basic Query

Course Details

Course code: ISQRY
Duration: 1 day
Maximum delegates: 8
Start time: 09:30
Price: £280

Jump to:

Introduction
What you will learn
Who should attend
Pre-requisites
Course content
Schedule

Actions:

Introduction

Query is one of the optional licensed programs shipped with the iSeries. It allows users to interrogate the database to produce enquiries and simple reports.

What you will learn

On completion of this course, you will be able to:

Understand key concepts of queries and query processing (files, libraries, interactive/batch etc.)
Use query to produce a report or enquiry from the database.
Create new query definitions, revise existing definitions, and run existing query definitions.
Getting the correct information into your query
Use the query presentation features to change the layout of the report.
Direct output from a query to a printer, or screen.
Create queries with totals and sub-totals.
Manipulate query spooled files.

Who should attend

This course is for end users 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

The Query design process.
Where do I start?
Selecting libraries.
Selecting a database file.
Query functionality.
Selecting and sequencing fields.
Selecting records.
Selecting report summary functions.
Final totals and sub totals.
Selecting output type, printer or display.
Selecting output form, summary or detail.
Saving a Query definition.
Changing existing Queries.
Selecting sort fields.
Selecting report column formatting.
Editing numeric and date fields.
Defining report breaks.
Selecting collating sequence.
Changing the presentation of a query
Running a query, interactive or batch.
Query design checklist.
Manipulating your spooled files.

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.

Schedule

Public schedule	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
	25		17		20		7		29	21		16
Northampton				15				4			11
We can run this course just for you - at our locations, a local hotel, or on your site. Please ask for details.

Top | Home

Tel: 01489 570803 | Email: training@sierra.co.uk