Overview
This course describes how to create and manage the logical files in a DB2 database. The course begins by describing how to use DDS statements define simple logical files. You will see how to:
- Specify an alternative ordering to the records in a physical file
- Allow access only to selected fields in each record in a physical file
- Extract selected records from a physical file
The course then describes how to define a join logical file and a multiple-format logical file using DDS statements. The course ends by showing how to perform various management and maintenance tasks on logical files.
Approximate Study Time: 2 hours
Objectives
After completing this course, you should be able to:
- Code the DDS statements to define a simple logical file that:
- Defines an alternative access path to a physical file
- Allows access only to selected fields from records in a physical file
- Allows access only to selected records in a physical file
- Define a field in a logical file that is a concatenation of two fields from a physical file
- Define a field in a logical file that is a substring of a field from a physical file
- Code the DDS statements to define a join logical file
- Code the DDS statements to define a multiple-format logical file
- Use PDM to create a logical file from DDS source
- Use the CRTLF command to create a logical file from DDS source
- Display the attributes of a logical file
- Change the attributes of a logical file
- Delete, copy, move, or rename a logical file
- Add a member to a logical file
Topic Outline
Defining a Simple Logical File
Defining a Join Logical File
Defining a Multiple-Format Logical File
Creating a Logical File
Working with Logical Files
Audience
This course is intended for programmers and application developers who will be creating DB2 databases. It should also be taken by anyone who will be creating and/or managing logical files.
Prerequisites
This course assumes that you have a basic knowledge of IBM i facilities. You can satisfy this prerequisite by successfully completing the Introduction to the IBM i Environment series. It also assumes that you have a basic knowledge of DB2 and DDS. In particular, you should know how to define a physical file using DDS. You can satisfy these prerequisites by successfully completing the first two courses in this series:
Overview
|
Courses
|
Options
|
Combo Packs
|
Technical
|
Orders
|
Legal
|
Contact Us
|
Search
|
Glossary
© Copyright 2023 Manta Technologies. All Rights Reserved.