Creating and Managing Physical Files This course also available online.
Author: Manta Technologies
Availability: Ships within 72 hours. SKU: 3088
Course Description: This course describes how to create and manage the physical files in a DB2 UDB 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.
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
Audience: This course is intended for programmers and application developers who will be creating DB2 UDB 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 OS/400 facilities. You can satisfy this prerequisite by successfully completing the Using an iSeries System series. It also assumes that you have a basic knowledge of DB2 UDB. You can satisfy this prerequisite by successfully completing the first course in the series, Introduction to DB2 UDB.
Course Outline: DDS Basics Defining a Data Physical File Creating a Physical File Using a Field Reference File Working with Physical Files
Course Details:
Length:
90 minutes
Materials:
A Student Reference Guide is available for this series.
Publisher:
Manta
Creating and Managing Physical Files This course also available online.
Creating and Managing Physical Files
