Duration
IBM i System (AS/400) Programmer Training
15 days
Audience
IBM i System (AS/400) technical users such as Programmers, Analyst Programmer & System Analyst who are new to IBM i.
Pre-Requisite
None
Objective
After completing this course, the participants will have a better understand about:
- IBM i System (AS/400) concepts.
- Using iOS (OS/400) utilities to create screen, designing report, data entry and coding programs.
- Able to write new and maintain existing RPG ILE programs.
- Create reporting program.
- Apply built-in function in RPG ILE.
- Developing Sub-File program.
- Data Queue concepts.
- Apply date and time operation in RPG ILE.
- Aldon application concept
- Control Language Programming.
- Using Query/400 to create query report and work file.
- Integrated Language Environment (ILE) concept.
- Usage of sub procedure
- Usage of Service Programs and Directory
- Activation group
- Embedded SQL Programming
- Dynamic SQL
- Applying embedded SQL statements in ILE RPG application.
- ILE RPG free style coding.
- Free format in program specifications
- Latest operation codes and built-in functions.
- RPG/400 coding
- Create report with RPG/400
Day 1
- Introduction to IBM i System (AS/400)
- Commands and menus in IBM i System.
- Introduction to IBM i System File Structure
- Introduction to Library List
- Introduction to Message Queue
- Introduction to Programming Development Manager (PDM)
- Creating Source Physical File
- Introduction to Source Entry Utility (SEU)
- Introduction to Physical File (PF)
- Reference File
- Parameter Files
- Introduction to Data File Utility (DFU)
Day 2
- Introduction to Logical File (LF)
- Creating Data File backup
- Reorganization of Physical File
- Introduction to Screen Design Aid (SDA)
- Creating Display File (DSPF)
- Using SDA
- Using SEU
- Overview of Compilation Listing
Day 3
- Introduction to RPG ILE.
- RPG ILE Program Specification
- Overview of Operation codes
- Arithmetic Operation in RPG ILE
- Arithmetic built-in functions
- Selection
- IF-ELSE
- SELECT
- CASE
- Looping
- DOW (Do while)
- DOU (Do until)
- FOR
- Usage of Subroutine
- Usage of Indicators
Day 4
- Introduction to Database File Operation in RPG ILE
- File Specification setting
- File Specification keywords
- Creating Database File Maintenance Program with functions:
- Add record (WRITE)
- Edit record (UPDATE)
- Display records (READ, READP, READE, PEADPE)
- Search records (CHAIN)
- Delete record (DELETE).
- Introduction to Program Debugging
Day 5
- Introduction to Array:
- Array types (3 types)
- Array operation
- Array Built-in Functions
- Introduction to Table
- Introduction to Data Structure:
- Data Structure types (7 types)
- Data Structure Operation
- Qualified Data Structure
- Creating Sub program and parameter list
Day 6
- Introduction to Report Layout Utility (RLU)
- Designing report and create Printer File
- Develop Reporting program
- Introduction to RPG ILE Built-in functions (BiF)
- Data type conversion BiF
- %CHAR, %DEC, %INT
- Character BiF
- %SUBST, %TRIM, %TRIML, %TRIMR, %SCAN, %SCANRPL, %LEN, %CHECK, %CHECKR, %LEN, %LOWER, %UPPER, %XLATE
- Numeric BiF
- %EDITC, %EDITW
Day 7
- Introduction to Sub file
- Designing Sub File using SDA
- Developing Database File maintenance program using Sub File
- Advanced Sub file programming techniques:
- Load All
- Load Partial
- Record Selection
Day 8
- Introduction to Data Queue.
- Developing RPG ILE program to handle Data Queue.
- Sender program
- Receiver program
- Introduction to Date and Time data type.
- Date and Time format
- Date and Time operation.
- Date and Time built-in functions
- Introduction to Aldon (concept)
Day 9
- Introduction to Control Language (CL) Program.
- CL Program structure
- Logical Operator
- Relation Operator
- Built-in Functions
- String concatenation
- Introduction to Message File
- Creating subprogram
- Retrieve external information using CL Program:
- Data Area
- Job Attributes
- Object Description
- User Profile
- Database File and Record selection using CL Program.
- Debugging CL Program
Day 10
- Introduction to Query/400
- Define query with file selection, record selection, select & sequence field, sort field, output type to Display screen and report.
- Define query: define result field, report column formatting, report summary functions, report break.
- Operation code and constant in query.
- Join file in query.
- Output form as an out file.
Day 11
- Introduction to ILE Concept
- Introduction to Sub Procedure and Module Binding.
- Introduction to Service Programs and Directory.
- CALLB v CALLP
- Activation group
Day 12
- Introduction to Embedded SQL programming
- Dynamic and static SQL
- Embedding SQL statements in ILE RPG application.
- SQL error codes
- Applied SQL in ILE RPG application:
- Subfile
- Reporting
- Record selection from Join files.
Day 13
- Free style coding (C spec)
- What’s new in free style?
- Operation codes that are not supported in free style
- Free format in other program specification:
- Control specification
- File specification
- Definition specification
- Procedure specification
Day 14
- Introduction to RPG/400
- Differences between RPG/400 and RPG ILE
- Usage of Input and Output specification
- Creating report with RPG/400
Day 15
- Assessment
Programme scope, delivery arrangements and suitability are confirmed during enquiry.