- OS/400 System Concepts & Architecture
- DB2/400 (DDS Interface)
- CL/400: CL Control Programming
- RPG Programming (RPG/400)
- ILE (Integrated Language Environment)
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)
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
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
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
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