- 4 hours
The Database Basics and the Need for Query course describes the IBM Query for i sort, report and analyze capabilities providing examples on how IBM Query for i is used to create business reports. Basic concepts relating to database structure and the data that can be accessed by IBM Query for i are explained in detail.
Personnel requiring knowledge about creating reports with the IBM Query for i facility.
Knowledge of IBM i concepts.
After completing this course the student should be able to:
- Describe the tasks that can be performed by IBM Query for i
- Identify the components that comprise a database
- Explain how database files and records are configured
The purpose of IBM Query for i
Physical and Logical Files
Data Description Specifications
Defining Record Formats
Record Configuration Examples
Example Database Need
How the Database is Used