YOUR IBM i TRAINING SOURCE

You must allow the browser to execute JavaScript programs if you want to view product information. If your browser is set up to execute JavaScript programs, the problem is that the product ID was incorrect. Use the menu bar above to find the desired product.

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: