iSeries Query

Audience

Query is a tool that is equally useful to programmers and users. Anybody who needs to view database data for any reason will benefit from attending.

Prerequisites

No specific prerequisites. Familiarity with using a 5250 screen is useful.

Duration

1 day. Hands on.

Course Objectives

The course introduces the concept of database files and explains all aspects of the Query tool. There are extensive hands-on exercises. After completing the course you will be able to explore and create Queries over standard DB2 database files. This will include reporting over multiple files and creating data extracts.

Course Content

Query Commands and Menus
Managing queries
File selection
Creating fields
Selecting and sequencing fields
Selecting records
Collating sequence
Column functions
Summary functions
Database output
Printed output
Display output