Verhoef Training

11 Kingsmead Square, Bath, BA1 2AB.
Tel: 01225 339705 Fax: 01225 339671




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.

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


PT08/01

© 2007 Verhoef Training, Ltd.