iSeries (AS/400) Advanced Query

Introduction

This course teaches delegates the techniques required to make the most of the capabilities of Query/400 when producing reports and files, and how Client Access Data Transfer can be used to download query files to a PC.

What you will learn

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

• Produce reports based on joining multiple files
• Customise your own sort orders
• Format columns to hide or enhance data
• Use cross-references in queries
• Produce summaries of previously summarised data
• Perform conditional select record criteria
• Perform numeric calculations
• Convert dates held in numeric or character format to proper dates, to perform date calculations
• Produce a file with query for subsequent download to a PC
• Use the RUNQRY command to useful effect

Who should attend

Staff who already have a familiarity with the basics of Query/400, who will be using Query/400 extensively, and need to learn how to produce complex reports, files for reports and/or download query files to a PC.

Pre-requisites

Delegates must have attended Sierra's iSeries Basic Query course or similar.

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

Course content

• Joining files
• Combining different join types to provide one simplified report, e.g. marketing reports, such as, which products need promoting to which companies
• Customised collating sequences - unusual sort orders
• Hiding sort fields not needed in reports
• Cross referencing files when join is not exact match, such as values to averages, prices to discount ranges
• Editing the appearance of fields, such as adding text to numeric data
• Queries on summary report data
• Performing IFs for conditional record selection
• Perform numeric calculations
• Concatenation and substring functions
• Date, time and timestamp functions
• Creating new fields combining various functions
• Formatting dates to be used in date calculations
• How to recognise and deal with calculation errors
• Ensuring valid data for data transfer to PCs
• Basic use of Client Access Data Transfer
• Advice on automating queries using RUNQRY
• Disabling interactive querying
• Technical information

Materials

A course manual with supporting documentation is provided. The course includes practical work to use Query/400 and download files to PC with Client Access Data Transfer.

Schedule

Top | Home

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

Sierra Training Services Limited.
P O Box 294, Sarisbury Green, Southampton, SO31 1WQ, ENGLAND.