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