Creating and Managing Logical Files This course is also available on CD-ROM
Presenter: Manta Technologies
Availability: Online SKU: 3589
Course Description: This course describes how to create and manage the logical files in a DB2 UDB 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.
After completing this course, you should be able to: • Code the DDS statements to define a simple logical 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
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 logical 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 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:
· Introduction to DB2 UDB
· Creating and Managing Physical Files
Course 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
Course Details:
Length:
90 minutes
Format:
Online Learning
Publisher:
Manta
Creating and Managing Logical Files This course is also available on CD-ROM
Creating and Managing Logical Files
