Duration
4 days
Audience
IBM System i technical users such as Programmers, Analyst Programmer & System Analyst
Pre-requisite
None
Objective
After completing this course, the participants will have a better understand about:
- IBM System i concepts.
- Using iOS utilities to create screen, menu, designing report, data entry and coding programs.
- Using Query/400 to create query report and work file.
- Able to write new and maintain existing RPG ILE programs.
- Create reporting program in RPG ILE.
- Built-in function in RPG ILE.
- Date and Time operation in RPG ILE.
- Developing Sub-File program.
- Data Queue concepts.
- Control Language Programming.
Day 1
- 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 2
- Introduction to ILE Concept
- Introduction to Sub Procedure and Module Binding.
- Introduction to Service Programs and Directory.
- Introduction to Data Queue.
- Developing RPG ILE program to handle Data Queue.
Day 3
- Introduction to Control Language (CL) Program.
- CL Program structure
- Logical Operator
- Relation Operator
- Built-in Function
- String concatenation
- Working with Message File
- Creating subprogram
- Retrieve external information using CL Program:
- Data Area
- System Values
- Job Attributes
- Object Description
- User Profile
- Database File and Record selection using CL Program.
Day 4
- 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.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.