Duration
5 days
Audience
IBM i System (AS/400) technical users such as Programmers, Analyst Programmer & System Analyst who has attended Basic level with 1-2 years’ working experience in ILE RPG environment.
Pre-Requisite
Basic level with 1-2 years’ working experience in ILE RPG environment.
Objective
After completing this course, the participants will have a better understand about:
- Integrated Language Environment (ILE) concept.
- Usage of sub procedure
- Usage of Service Programs and Directory
- Activation group
- Understanding SQL/400 Concepts
- Quick Tour of Query Manager
- Interactive SQL/400 Environment
- User & Data Security
- Creating Tables and Indexes
- SQL Select Clause and Join Tables
- SQL Built-In Functions
- SQL Optimization Techniques
- Sub-select Queries
- Embedded SQL Programming
- Dynamic SQL
- Applying embedded SQL statements in ILE RPG application.
- Security concept.
- Subsystem and Job Description
- Handling batch job and batch job error.
- Creating FTP program.
Day 1
- Introduction to ILE Concept
- Introduction to Sub Procedure and Module Binding.
- Introduction to Service Programs and Directory.
- CALLB v CALLP
- Activation group
Day 2
- Understanding SQL/400 Concepts
- Quick Tour of Query Manager
- Interactive SQL/400 Environment
- User & Data Security
- Creating Tables and Indexes
- SQL Select Clause and Join Tables
Day 3
- SQL Built-In Functions
- SQL Optimization Techniques
- Sub-select Queries
Day 4
- 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 5
- Introduction to Security concept in IBM i
- Object authority
- Group profile
- Authorization list
- Introduction to Subsystem, Job Description and Batch Job
- Introduction to Service Job
- Handling batch error
- File Transfer Protocol (FTP) program.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.