Format

Classroom

Duration

3.0 Day(s)

Description

This course will teach the student the basic structure of database files on the AS/400 and how to define, run and change queries of those files, using the IBM Query for AS/400 program product (5679-QU1 for V4 or 5722-QU1 for V5).

Audience

This course is intended for programmers and non-programmers. It is intended for anyone who needs to produce reports from a DB2 UDB for iSeries files with which they are familiar.

Prerequisites

Students should be able to select options from an AS/400 menu and enter AS/400 commands.

Objectives

After completing this course, you should be able to:
o Describe the structure of physical and logical files and how they are defined on the AS/400
o List the major features and functions of AS/400 Query
o Define a query with multiple break levels and summary calculations
o Define a query with result fields that are computed using arithmetic calculations
o Embed a field name in break text
o Perform summary calculations on result fields
o Select records based on whether or not a field is NULL
o Use data-type fields in a query
o Use date, time and timestamp expressions in result fields
o Compute a date duration between two fields that contain dates, but which are character or numeric fields, not date-type fields
o Use the DIGITS function to return the character representation of a number
o Use substring and concatenation operations to manipulate character fields
o Define queries for all three types of joins allowed by query:
1 . Matched records
2 . Matched records with primary file
3 . Unmatched records with primary file
o Join three files in one query
o Define a query with fields of length zero so it will not show in the detail lines of a report, but will be available in break text
o Write a query in which fields in detail lines are compared to break level summary values