AS/400 Course Curriculum

Best Kitchen Appliances Offers

Duration: 3. Months

Total: 56 Hours Theory+ 150 hours practical + 60 hours project

OS/400 System Concepts & Architecture

                                    -6 Hours (Theory 6 hrs, Practical 0 hrs)

Ø  Overview of the system

Ø  General awareness of the AS400 Server

Ø  Libraries, Files and Members

Ø  Library list concept and related commands

Ø  Functions of OS/400

Ø  Architecture

Ø  ADTS (Application Development Tool Set)

DB2/400 (DDS Interface)

- 24 Hours (Theory 6 hrs, Practical 18 hrs)

Ø  Overview of DB2/400 Concept

Ø  Externally Described files Source Files Physical Files, Logical Files

Ø  Field Reference Files

Ø  Database Integrity

Ø  Commitment Control and Journaling

Ø  Creating tables

Ø  Insert/Update/Delete Using SQL

Ø  Using cursors in RPG/400

CL/400: CL Control Programming

- 40 Hours (Theory 10 hrs, Practical 30 hrs)

Ø  File Handling in CL/400

Ø  Handling Errors and Messages

Ø  Handling Data Areas

Ø  Overriding file Attributes and the scope of overrides

Ø  Open Query File

Ø  String Operators String Functions

RPG Programming (RPG/400)

- 100 Hours (Theory 25 hrs, Practical 75 hrs)

Ø  Introduction to RPG/400

Ø  Specifications

Ø  Operation Codes

Ø  Subroutines

Ø  Data Structures

Ø  Tables and Arrays

Ø  Indicators

Ø  RPG Logic Cycle

Ø  Sub Files

o   Load All Subfile

o   Page Load Subfile

o   Expanding Subfile

o   Message Subfile

ILE (Integrated Language Environment)

 - 36 Hours (Theory 9 hrs. Practical 27 hrs)

Ø  Introduction to ILE

Ø  Specifications

Ø  Advantages of ILE

Ø  ILE Program Concept

Ø  Advanced Concept of ILE

Mini Proiect

-60 hrs (Practical 60 hrs)