Query
Duration
1 dayWhat the Course Covers
The course introduces the concept of database files and explains all aspects of the Query tool. There are extensive hands-on exercises.How Can You Apply the Skills You Will Learn?
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.Who Should Attend
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
Familiarity with using a 5250 screenAgenda
The following topics will be covered- 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