Introduction

The Application System/400 (also known as AS/400), now System i (also known as iSeries), is a type of minicomputer produced by IBM. It was first produced in 1988. It was then renamed to  the eServer iSeries in 2000 as part of IBM’s e-Server branding initiative. Now with the global move of the server and storage brands to the System brand with the Systems Agenda, the family has been renamed to System i in 2006, with the POWER5-based members of the series being called the System i5. The AS/400 is an object-based system with an integrated DB2 database that was designed to implement E. F. Codd’s relational database model, which is based on Codd’s 12 rules, in the operating system and hardware.

Prerequisties

• All attendees should have a basic knowledge of java programming language and also distributed systems concepts.

Course Content

1. OS/400 System Concepts & Architecture

• Overview of the system
• General awareness of the AS/400 System
• Libraries, Files and Members
• Library list concept and related commands
• Functions of OS/400
• Architecture
• ADTS (Application Development Tool Set)

2.DB2/400 (DDS Interface)

• Overview of DB2/400 Concept
• Externally Described files
• Source Files
• Physical Files, Logical Files and Join Logical Files
• Field Reference Files
• Database Integrity
• Commitment Control and Journaling
• Creating tables
• Insert/Update/Delete Using SQL
• Using cursors in RPG/400
• Triggers
• Report designing using RLU tool.

3. CL/400: CL Control Programming

• File Handling in CL/400
• Handling Errors and Messages
• Handling Data Areas
• Handling Data Queues.
• Overriding file Attributes and the Scope of overrides
• Open Query File
• String Operators
• String Functions

4.RPG Programming (RPG/400)

• Introduction to RPG/400
• Specifications
• Operation Codes
• Subroutines
• Data Structures
• Tables and Arrays
• Indicators
• Built-in functions
• RPG Logic Cycle
• Sub Files
• Load All Subfile
• Page Load Subfile
• Expanding Subfile
• Exception handling
• Database file processing(external/Internal)
• Printing reports.
• Program defined printer file and externally described printer file.
• Embedded SQL Programming
• RPG free format programming

5.ILE (Integrated Language Environment)

• Introduction to ILE
• Specifications
• Advantages of ILE
• ILE Program Concept
• Module
• Binding Directory
• Procedure
• Program
• Service Program
• Binder Language
• Bind By Reference
• Bind By Copy