Data Base Administration I (Data Description Specifications)

Data Base Administration I
(Data Description Specifications)

Course Code: ADB1

Description

Data Base Administration I is a self-paced, multimedia course providing comprehensive, practical training in describing and creating physical and logical files.

Upon completion you'll be able to:

Use Data Description Specifications (DDS) to define physical and logical files.

Define alphanumeric and numeric fields and assign attributes that validate user- entered data, present the data in edited form, allow input only, output only, or both, and other useful attributes.

Create a field reference file that serves as the single-source supplier of field attributes to other files.

Create files that allow only one file member, or an unlimited number of file members, and be able to add, clear, or remove file members.

Create logical files that concatenate two or more fields into one field and split a field into smaller fields.

Create files indexed by one or more fields, permit or restrict duplicate keys, or sequence records in FIFO or LIFO order.

Create logical files that join or interleave records from two or more files and select records based on the value of one or more fields.

Specify how a file's access path should be maintained by the system for performance.

Use OS/400 CL commands to display descriptions of files, fields, and the relationships between physical and logical files.


Physical Files Record Format Definitions Field Definitions Field Naming Conventions Key Field Definitions Field Reference Files DDS Keywords TEXT and COLHDG ALIAS EDTCDE and EDTWRD COMP, RANGE, and VALUES CHECK REF and REFFLD FORMAT Multiple Members	Logical Files Record Format Definition Field Definitions Access Path Definitions Select/Omit Definitions DDS Keywords RENAME CONCAT DYNSLT CONCAT,SST Multiple Members Multiple Record Formats Join Logical Files Joining Physical Files Field Definitions Access Path Definitions Select/Omit Definitions DDS Keywords JOIN JFILE JFLD JREF DUPSEQ	Access Paths Arrival Sequence Keyed Sequence Maintenance Types IMMED REBLD DLY DDS Keywords DESCEND UNIQUE LIFO NONE Key Field Definition File Handling CL Commands

Audience Any programmer, systems analyst, or data base administrator who will have the task of defining and creating data base files. Prerequisites Workstation Operations System Operations	Format Self-Instructional Materials Seventeen Audio CDs Student Text Workbook Interactive Media	Time Required Approximately 15 Hours