|   AS/400 Database Administration I
Author: MultiplePrice: $995.00
Availability: Ships within 72 hours
SKU: 710 | |
 
Course Description:
AS/400 Database Administration I is a self-paced audiocassette course providing comprehensive, practical training in the description and creation of physical and logical files. Includes ten audiocassettes; student text; workbook; Interactive media
When you have completed of this course, you will 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 data in edited form; allow input only, output only, or both; and more
• Create a field reference file that serves as single-source supplier of field attributes to other files
• Create files that allow an unlimited number of file members or only one file member
• Create files that can add, clear, or remove file members
• Create logical files that concatenate multiple fields into one field or split a field into smaller fields
• Create files indexed by multiple fields, permit or restrict duplicate keys, and sequence records
• Create logical files that join or interleave records from two or more files
• 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 more
Audience: Database Administrators and Programmers
Prerequisites: Workstation Operations and AS/400 System Operations
Course Outline:
Physical Files
Record Format Definitions
Field Definitions
Field Naming ConventionsKey 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[SW1]
Multiple Members
Multiple Record Formats
Joining Logical Files
Joining Physical Files
Field Definitions
Access Path Definitions
Select/Omit Definitions
DDS Keywords
JOIN
JFILE
JFLD
JREF
JDUPSEQ
Access Paths
Arrival Sequence
Keyed Sequence
Maintenance Types
*IMMED
*REBLD
*DLY
DDS Keywords
DESCEND
UNIQUE
LIFO
*NONE
Key Field Definition
File-handling CL Commands
Course Details: | Level: | Intermediate | | Subject: | Database Administration | | Length: | 15 hrs. | | Publisher: | ATS | | Publish Date: | June 1998 |
AS/400 Database Administration I
Author: MultiplePrice: $995.00
Availability: Ships within 72 hours
SKU: 710 | |
| |
© 2001-2003 MC Press Online, LP. IBM® and AS/400® are registered trademarks of IBM.
All other product names are trademarked or copyrighted by their respective holders.
MC Press Online Privacy Policy
|
|
|
