Manta alt

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 physical files in a DB2 database. The course begins by describing the basics of DDS coding and how to create a DDS source member. It then covers how to define a physical file using DDS. Next, the course shows how to use the CRTPF command to create a physical file from DDS, and how to use the CRTSRCPF command to create a source physical file. The course then describes field reference files. It shows how to both create and use a field reference file. The course ends by showing how to perform various management and maintenance tasks on physical files.

Approximate Study Time: 90 minutes

Objectives

After completing this course, you should be able to:

  • Use the SEU to create a DDS source member
  • Code the DDS statements to define a data physical file
  • Use PDM to create a data physical file from DDS source
  • Use the CRTPF command to create a data physical file from DDS source
  • Use the CRTSRCPF command to create a source physical file
  • Define and create a field reference file
  • Use field referencing when defining a physical file
  • Display the attributes of a physical file
  • Change the attributes of a physical file
  • Delete, copy, move, or rename a physical file
  • Reorganize a physical file
  • Add a member to a physical file
  • Remove a member from a physical file
  • Rename a member in a physical file

Topic Outline

DDS Basics

Defining a Data Physical File

Creating a Physical File

Using a Field Reference File

Working with Physical 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 physical 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. You can satisfy this prerequisite by successfully completing the first course in the series, Introduction to DB2.