India: +91 90300 10123

Whatsapp:+1 516 8586 242

India: +91 40 6050 1418

USA: +1 909 233 6006

UK: +44 (0)203 371 0077

AS400 administration-online training

AS/400 Administration Training Introduction:

AS/400 Administration Online Training Course Content

OS/400 System Concepts & Architecture
  • Overview of the system
  • General awareness of the AS/400 System
  • Libraries, Files & Members
  • Library list concept & related commands
  • Functions of OS/400
  • Architecture
  • ADTS (Application Development Tool Set)
DB2/400 (DDS Interface)
  • DB2/400 Concept Overview
  • Externally Described files
  • Source Files
  • Physical Files, Logical Files & Join Logical Files
  • Field Reference Files
  • Database Integrity
  • Commitment Control & 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 & Messages
  • Handling Data Areas
  • Handling Data Queues.
  • Overriding file Attributes & 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)
  • ILE Introduction
  • Specifications
  • Advantages of ILE
  • ILE Program Concept
  • Module
  • Binding Directory
  • Procedure
  • Program
  • Service Program
  • Binder Language
  • Bind By Reference
  • Bind By Copy