GASI EDUCATION CENTER

SYLLABUS

“AS / 400 DATA BASE FUNDAMENTAL”

Course Code : GSDB1 

♦      COURSE OBJECTIVE

This course is designed to provide comprehensive partical training in the use of data Description Specifications. The student will be presented with many Data Base concepts and will apply these concepts interactively with the course.

♦       COURSE PREREQUISITES

Students taking this course should have completed the following GASI AS / 400 courses or have equivalent  experiences :

AS / 400 Workstation Operations

AS / 400 System Operations

♦      COURSE PROGRAM CONTENTS

⇒    Physical Files

• Record Format Definitions
• Field Definitions
• Field Naming Conventions
• Key Field Definitions
• DDS Keywords
  • TEXT and COLHDG
  • ALIAS
  • EDTCDE, RANGE and VALUES
  • CHECK
  • REF and  REFFLD
  • FORMAT
• Multiple Members

⇒    Logical Files

• Record Format Definition
• Field Definitions
• Access Path Definition
• Select / Omit Definitions
• DDS Keyword
  • 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 Keyword
  • JOIN
  • JFILE
  • JFLD
  • JREF
  • JDUPSEQ

⇒    Access Path

• Arrival Segue
• Keyed Sequence
• Maintenance Type
  • *IMMED
  • *REBLD
  • *DLY
• DDS Keyword
  • DESCEND
  • UNIQUE
  • LIFO
  • *NONE
• Key Field Definition

⇒    File Handling CL Commands

♦      COURSE METHODS

This training program is designed to provide participants with an interactive learning experience. As the word implies, this course dose more than just provide a lecture. Instead, participants will actively involved  in the operation of the AS / 400. In addition, participants will be called on

to test participants knowledge by answering some short quizzes. Participants  will also perform some Hands On exercises.

♦      COURSE DURATION       

3 Days