Specification :
IBM AS/400 [Duration 96 hours]
Prerequisite: Knowledge of any database or programming language
Course Content
---------------------------------------------
Day-1
- History & Overview of AS/400
- AS400 System Architecture
- OS/400 Basic Concepts
- Introduction to OS 400 Object
Management Concepts
- Data Description Specification (DDS)
- DB2/400
- Files
- Programming Development Manager
Utility
- Source Entry Utility (SEU), Methods
of involving SEU
- Line commands, Command Line
Options
- Work with Library, Object, Member,
User-Defined Options
Day-2
- Data File Utility (DFU)
- Database Level Keywords
- Multiple Members
- Function keys used in SEU
- Access Path
- File Management Commands
Day-3
- Logical Files - Non Join & Join
- Logical file keywords
Day-4
- Introduction to QRY/400 & its usage
- Introduction to SQL/400 & its usage
Day-5
- Introduction to Screen Design Aid (SDA)
- Creating Menus
Day-6
- CL Programming
- PGM, ENDPGM Commands
- Declare commands – Variable, File
declaration
- CL Processing commands,
Comment lines, Labels
- User Interface, CL expressions,
Built-in functions
- Logic control commands, Invoking
Programs, Submitting JOBS
- Parameters, Retrieve commands,
Error Handling
Day-7
- Introduction to RPG Programming
- Brief History
- Basic Concepts, RPG Specifications
- Introduction to indicators
- RPG Logic cycle
- File descriptions- Program
Described & External
- Program compilation & Execution
- Opcodes
- Full procedural programming
- Semantics-Expressions
Day-8
- More Opcodes
- Display file processing & User
Interface
- Data base File processing
- Control & Iterative constructs,
Subroutines, Figurative constants
Day-9
- Key lists processing, Built-in functions
- Character Manipulation
- Date and Time operations
Day-10
- Data structures
- Data areas
- Arrays
- Embedded SQL
Day-11
- Subfiles
- Definition, Record formats,
keywords
- Methods of building subfile
- Possible operations on subfile
- Subfile vs. Database files
Day-12
- Report Writing Tools
- Introduction to Report Layout Utility
(RLU)
- RLU Usage, Designing a report with
RLU
– Working with Record Formats, fields
- keywords, Limitations, Using RLU in
RPG