iSeries (AS/400) Advanced Query

Introduction

This course is intended for end users and support staff who need to learn the advanced features of the Query licensed program. The course includes joining files in different ways, output the results of a query to a database file in different ways, create new fields for numeric calculations, date and time conversions, substringing, concatenation etc. and transferring files generated by query to your PC.

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 the iSeries Basic Query course or have equivalent knowledge.

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

• How to join files
• Detail the different types of join
• Examples of different types of joins
• How to produce a report in your own user defined sequence
• Selecting a Collating Sequence
• How to hide a field from the final report that you have sorted on
• Perform substring and concatenate expressions ( i.e. extract part of a character field and join character fields into one field).
• How to output a query definition to a database file in different ways
• Subsequent use of the output file in further queries
• Perform queries on summary data
• Using the QTEMP library
• Perform numeric calculations on fields
• Use of Edit Codes
• How to use Edit Words to add your own text to a field
• How to sort on mixed case fields
• How to convert fields from numeric to character
• How to convert character fields to date and then format the date
• Perform date calculations
• Time and timestamp functions and calculations
• Use rounding on numeric calculations and other processing options
• How to download a query output file to a PC
• How to create a Data transfer from the desktop
• Data transfer from a "green screen" session
• Securing query definitions and query output files
• Using the RUNQRY command
• Disabling interactive queries
• Automating Queries
• Hints and Tips on creating and running queries
• Tips on Joining Files

Materials

A course manual with supporting documentation is provided.

Schedule