Keterangan :

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