AS/400 Links Partner with Rochester Institute Contact Us
Training Catalog Free Downloads Privacy / Usage


IBMi and AS400 Training
HOME >> Training Catalog >> iSeries Data Base Administration I

iSeries Data Base Administration I (ADB1)
Author: ATS
$995




Save when this course is included with the
RPG IV Programming training bundle!


Save when this course is included with the
RPG Basics and Beyond training bundle!

Description
iSeries Data Base Administration I is a self-paced, audio CD 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
iSeries Workstation Operations
iSeries System Operations
Format
Self-Instructional
Materials
17 Audio CDs
Student Text
Workbook
Interactive Media
Time Required
Approximately 15 Hours

Save when this course is included with the
RPG Basics and Beyond training bundle!


iSeries Data Base Administration I (ADB1)
Author: ATS
$995



Rochester Training
     RPG Skills Accelerator - Volume 2
     RPG Skills Accelerator
     e-RPG Powertools – Stone on CGIDEV2
     WebFacing Now! WAS-Express Edition
     JDBC and Record Level Access
with IBM AS/400 Toolbox for Java
     Turbo Query/400
     XML Web Services for RPG Programmers
     RPG Modernization with WDSC (from III to IV to /Free)
     Microsoft .NET for RPG Programmers (Visual Basic Version)
     Microsoft .NET for RPG Programmers (C# Version)
     iSeries Navigator for Programmers (V5R3 Edition)
     SQL for RPG Programmers
     Subprocedures for RPG Programmers
     RPG Web Skills Accelerator
     WDSC for RPG Programmers (Version 7)
     WDSC for RPG Programmers (Version 6)
     Microsoft Word with the iSeries
     Microsoft Excel with the iSeries
Operations Training
     iSeries Advanced System Operations
     iSeries System Operations
     iSeries Startup Operations
     iSeries Security
     iSeries Work Management
User Training
     iSeries Query for Users
     iSeries Query for Advanced Users
     iSeries RPG/400 Programming
     iSeries RPG/400 Interactive Programming
     iSeries RPG/400 Advanced RPG Programming
     iSeries RPG/400 Subfile Programming
     iSeries RPG IV Programming
     iSeries Data Base Administration I
     iSeries Data Base Administration II
     iSeries Control Language Programming
     iSeries CL and Programming Techniques
     iSeries SQL/400
     iSeries Advanced COBOL/400 Programming
     iSeries Interactive COBOL/400 Programming
     iSeries COBOL/400 Programming
     iSeries COBOL/400 Subfile Programming
     iSeries Program Development
Training Bundles
     iSeries Operations & Administration Bundle
     Microsoft Word and Excel with the iSeries Bundle
     RPG Skills Accelerator & RPG Web Skills Accelerator
     RPG Basics and Beyond (training bundle)
     RPG Skills Accelerator & RPG Skills Accelerator - Volume 2