IBM i (AS/400)

Featured Review

4.5 (2387 Ratings)

IBM i (AS/400) Training is a 40-hour, job-oriented program designed to build practical skills in the IBM i platform running on IBM Power Systems. The course covers RPG programming, CL programming, Db2 for i, IBM i administration, jobs, objects, security, troubleshooting, and production support. Learners gain hands-on knowledge through job-oriented projects and develop the skills needed to work with IBM i environments. This course is ideal for beginners, aspiring IBM i developers, system administrators, IT professionals, and support engineers looking to build or advance their careers in IBM i (AS/400) technologies.

Duration of Training : 40 Hours
Batch type : Weekdays/Weekends
Mode of Training : Classroom/Online/Corporate Training
Detailed Syllabus • Hands-on Labs • Assignments • Support-Focused • Implementation

0 +

Google Reviews

0 +

JustDial Reviews

Overview

The Syllabus

Curriculum Designed by Experts

1. Course Overview

This course provides practical, job-oriented training on the IBM i (AS/400) platform, covering system fundamentals, IBM i architecture, RPG programming, CL programming, Db2 for i, jobs, objects, security, troubleshooting and production support.

Key Learning Outcomes
• Understand IBM i / AS/400 architecture and components.
• Work with libraries, objects, jobs and subsystems.
• Develop applications using RPG / RPGLE.
• Write CL programs and CL commands.
• Work with Db2 for i databases using SQL.
• Understand batch and interactive jobs.
• Perform debugging and production troubleshooting.
• Work with IBM i security and user profiles.
• Understand application deployment and change management.
• Prepare for IBM i Developer / Application Support roles.

2. Prerequisites

• Basic programming concepts
• Basic database concepts
• Basic SQL knowledge is beneficial
• Basic understanding of operating systems
• No prior AS/400 experience required

Suitable for:
• Freshers
• Mainframe / COBOL professionals looking to cross-train
• RPG developers
• Software developers
• Application support engineers
• Production support engineers
• IBM i administrators
• ERP / enterprise application professionals

IBM i / AS/400 Fundamentals

IBM i Introduction
• What is AS/400?
• Evolution: AS/400 → iSeries → System i → IBM i
• IBM Power Systems
• IBM i operating system
• IBM i architecture
• Integrated database concept
• Single-level storage
• Objects and libraries
• Jobs and subsystems
• Work management
• IBM i application ecosystem

IBM i Objects
• Libraries
• Objects
• Source physical files
• Physical files
• Logical files
• Program objects
• Module objects
• Service programs
• Job queues
• Output queues
• User profiles

Core Technical Topics — Main Syllabus

Module 1 — IBM i Navigation & Commands

• IBM i command structure
• Command line
• Library lists
• Current library
• Object naming
• WRKOBJ
• WRKLIB
• WRKJOB
• WRKACTJOB
• WRKSPLF
• WRKOUTQ
• WRKUSRJOB
• DSPJOB
• DSPPGM
• DSPLIB
• DSPFD
• DSPFFD
• IBM i menus
• Job logs
• Message handling

Module 2 — IBM i Work Management

• Jobs
• Job types
• Interactive jobs
• Batch jobs
• Prestart jobs
• Job queues
• Output queues
• Subsystems
• Job descriptions
• Job priorities
• Job logs
• Job lifecycle
• Job scheduling
• Batch processing
• Work management troubleshooting

Module 3 — CL Programming

CL Fundamentals
• Introduction to Control Language
• CL commands
• CL programs
• Variables
• Parameters
• Conditional processing
• Loops
• Program calls
• Message handling
• Error handling

Advanced CL
• CLLE
• Command parameters
• RTV commands
• DCL
• CHGVAR
• IF/ELSE
• DO loops
• MONMSG
• SNDPGMMSG
• CALL
• SBMJOB
• Data areas
• Data queues
• Automated batch processing

Module 4 — RPG Programming

RPG Fundamentals
• Introduction to RPG
• RPG history
• RPGLE
• RPG program structure
• Free-form RPG
• Variables
• Data types
• Expressions
• Operators
• Conditional statements
• Loops
• Procedures
• Subprocedures
• Parameters
• Arrays
• Data structures

Modern Free-Form RPG
• Fully free-form RPG
• Control options
• File declarations
• Variable declarations
• Procedures
• Built-in functions
• Error handling
• Modular programming

Module 5 — RPG Database Programming

• RPG with Db2 for i
• File declarations
• Database operations
• READ
• CHAIN
• SETLL
• SETGT
• READE
• READP
• WRITE
• UPDATE
• DELETE
• File positioning
• Record locking
• Commitment control
• Transaction processing

Advanced Database Access
• Embedded SQL
• SQL in RPG
• Cursors
• Dynamic SQL
• SQL error handling
• SQLCODE
• SQLSTATE

Module 6 — Db2 for i & SQL

Database Fundamentals
• Db2 for i architecture
• Tables
• Views
• Indexes
• Constraints
• Primary keys
• Foreign keys
• Referential integrity

SQL
• SELECT
• INSERT
• UPDATE
• DELETE
• JOIN
• Subqueries
• CTEs
• Aggregations
• GROUP BY
• HAVING
• CASE
• Window functions

Advanced Db2
• Stored procedures
• Functions
• Triggers
• Views
• Indexing
• Query optimization
• SQL performance analysis

Module 7 — IBM i Files

• Physical files
• Logical files
• Source physical files
• Record formats
• Key fields
• Access paths
• Join logical files
• Override commands
• File-level concepts
• DDS fundamentals
• DDS vs SQL DDL

Module 8 — IBM i Security

• IBM i security architecture
• User profiles
• Group profiles
• Object authority
• Library authority
• Private authority
• Public authority
• Adopted authority
• Authorization lists
• Password policies
• Security auditing
• Security-related troubleshooting

Module 9 — Debugging & Troubleshooting

• Program errors
• Compile errors
• Runtime errors
• Job logs
• Program messages
• CPF messages
• RPG error handling
• SQL errors
• Debugging RPG programs
• STRDBG
• Service jobs
• Job investigation
• Application troubleshooting
• Production incident analysis

Module 10 — Advanced IBM i Development

• Service programs
• Modules
• Binding directories
• Activation groups
• APIs
• Calling external programs
• Procedures
• Modular application design
• Batch application architecture
• Interactive application architecture
• Error-handling frameworks
• Application deployment

5. Hands-On Labs

Lab 1 — IBM i Environment Navigation
Explore libraries, objects, jobs and system resources.

Lab 2 — IBM i Command Lab
Execute commonly used IBM i commands.

Lab 3 — Library & Object Management
Create, inspect and manage IBM i objects.

Lab 4 — Job Management Lab
Monitor interactive and batch jobs.

Lab 5 — CL Programming Lab
Create a CLLE program with parameters and error handling.

Lab 6 — RPGLE Programming Lab
Develop a basic RPGLE application.

Lab 7 — Free-Form RPG Lab
Build a modern free-form RPG application.

Lab 8 — Db2 SQL Lab
Create tables and perform SQL operations.

Lab 9 — RPG + Db2 Integration Lab
Develop an RPG program that reads and updates database records.

Lab 10 — Batch Processing Lab
Submit and monitor a batch application.

Lab 11 — Debugging Lab
Identify and fix RPG application errors.

Lab 12 — Production Support Lab
Analyze job logs and troubleshoot a simulated production issue.

6. Assignments

1. IBM i Architecture & Object Identification
2. Library and Object Management
3. IBM i Command Practice
4. Job Management Assignment
5. CL Command Assignment
6. CLLE Automation Program
7. RPG Variables & Data Structures
8. RPG Conditional Processing
9. RPG Loops & Arrays
10. RPG Procedures & Subprocedures
11. RPG File Processing
12. Db2 SQL Query Assignment
13. SQL Join & Aggregation Assignment
14. RPG + Db2 CRUD Application
15. Batch Job Processing
16. Error & Message Handling
17. RPG Debugging Exercise
18. IBM i Security Assignment
19. Performance Troubleshooting Exercise
20. Production Support Case Study

7. Mini Projects

Mini Project 1 — Employee Management System
Develop an IBM i application for:
• Employee creation
• Employee updates
• Employee search
• Department management
• Employee reporting
Technologies: RPGLE + CLLE + Db2 for i

Mini Project 2 — Inventory Management System
Features:
• Product master
• Stock management
• Stock transactions
• Purchase entries
• Sales transactions
• Inventory reports

Mini Project 3 — Banking Account System
Features:
• Customer master
• Account creation
• Deposits
• Withdrawals
• Balance inquiry
• Transaction history

Mini Project 4 — Order Management System
Develop:
• Customer management
• Product management
• Order entry
• Order processing
• Invoice generation
• Order reporting

8. Capstone Projects

Capstone Project 1 — Enterprise Order Processing System
Build a complete IBM i application covering:
Customer → Product → Order → Inventory → Invoice → Reporting

Deliverables
• Database design
• Db2 tables
• RPGLE programs
• CLLE automation
• Batch processing
• Error handling
• Security considerations
• Reports
• Testing
• Production deployment plan

Capstone Project 2 — IBM i Production Support Simulation
Students work through simulated production incidents involving:
• Failed batch jobs
• Database errors
• Locked records
• Program failures
• Job queue problems
• SQL errors
• Performance issues
• User authorization problems

9. Real-Time Job-Oriented Scenarios

Students practice scenarios commonly encountered in IBM i development and support:
1. A nightly batch job fails during production processing.
2. RPG program receives a runtime error.
3. User cannot access a required object.
4. Database record is locked by another job.
5. SQL query is running significantly slower than expected.
6. Order-processing program fails while updating inventory.
7. Batch job remains in a job queue.
8. Program is unable to find an object because of library-list issues.
9. RPG program produces incorrect database results.
10. Production job requires investigation through the job log.
11. A CL automation process needs error handling.
12. An application change needs to be moved between environments.
13. A logical file/access path problem affects application performance.
14. A user receives an IBM i CPF error message.
15. A scheduled job does not execute as expected.

10. Troubleshooting Scenarios

Scenario 1 — Batch Job Failure
Investigate: Job log → error message → program → database → corrective action.

Scenario 2 — RPG Runtime Error
Investigate: Program flow, variables, file operations and error handling.

Scenario 3 — Record Lock
Investigate: Active jobs, locked objects/records and transaction status.

Scenario 4 — SQL Performance Issue
Investigate: Query structure, indexes/access paths and execution behavior.

Scenario 5 — Authorization Failure
Investigate: User profile, group profile and object authority.

Scenario 6 — Object Not Found
Investigate: Library list, object existence and deployment configuration.

Scenario 7 — Failed Scheduled Job
Investigate: Job scheduler, job description, job queue and job log.

11. Industry Tools & Technologies

IBM i Development
• IBM i
• IBM Power Systems
• RPGLE
• CLLE
• Db2 for i
• SQL
• DDS

Development / IDE
• IBM Rational Developer for i (RDi)
• IBM i Access Client Solutions (ACS)
• SEU
• PDM

Administration & Monitoring
• IBM Navigator for i
• WRKACTJOB
• WRKJOB
• WRKSPLF
• WRKOUTQ
• System i Navigator / relevant IBM i management interfaces

Database / Development
• Db2 for i
• SQL
• Stored Procedures
• Triggers
• APIs

12. Best Practices

• Use modern free-form RPG for new development where appropriate.
• Prefer SQL-based database development where suitable.
• Follow modular programming practices.
• Use meaningful naming conventions.
• Implement structured error handling.
• Maintain proper job and logging practices.
• Follow least-privilege security principles.
• Avoid unnecessary database access inside loops.
• Analyze SQL and application performance before making changes.
• Maintain proper source-code and deployment controls.
• Document production support procedures.
• Test changes thoroughly before production deployment.
• Maintain separation between development, testing and production environments.

13. Certification Names

Potential certification/training pathways include:

• IBM Certified Application Developer – IBM i
• IBM i Application Development Certification
• IBM i Administration Certification
• IBM i Technical Training Certificate
• RPGLE Programming Certificate
• Db2 for i SQL Certificate
• IBM i System Administration Certificate

Certification availability and current exam names should be verified with IBM because certification programs and exam codes can change.

14. Mock Interviews

Technical + scenario-based preparation covering:
• IBM i architecture
• RPGLE
• CLLE
• Db2 for i
• SQL
• Jobs & subsystems
• IBM i commands
• Debugging
• Production support
• Security
• Real-time incident scenarios

15. Resume Preparation

Create an IBM i / AS400-focused resume highlighting:

• RPGLE
• CLLE
• Db2 for i
• SQL
• IBM i commands
• Batch processing
• Production support
• Debugging
• Projects
• Application development experience

Convert mini/capstone projects into professional, resume-ready project descriptions.

16. Placement Assistance

• IBM i job-role guidance
• Resume optimization
• Job-description analysis
• Technical interview preparation
• RPG/Db2 coding practice
• Production-support scenario preparation
• Mock interviews
• LinkedIn profile guidance
• Job application guidance
• Interview feedback

Target Job Roles
• AS/400 Developer
• IBM i Developer
• RPG Developer
• RPGLE Developer
• IBM i Application Developer
• AS/400 Production Support Engineer
• IBM i Support Engineer
• IBM i Administrator
• Db2 for i Developer
• IBM i Technical Consultant
• IBM i Application Support Engineer

Enquire Now

Why Radical Technologies

Live Online Training

Highly practical oriented training

Installation of Software On your System

24/7 Email and Phone Support

100% Placement Assistance until you get placed

Global Certification Preparation

Trainer Student Interactive Portal

Assignments and Projects Guided by Mentors

And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Live Classroom Training

Weekend / Weekdays / Morning / Evening Batches

80:20 Practical and Theory Ratio

Real-life Case Studies

Easy Coverup if you missed any sessions

PSI | Kryterion | Redhat Test Centers

Life Time Video Classroom Access ( coming soon )

Resume Preparations and Mock Interviews

And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Self Paced Training

Self Paced Learning

Learn 300+ Courses at Your Own Time

50000+ Satisfied Learners

Course Completion Certificate

Practical Labs Available

Mentor Support Available

Doubt Clearing Session Available

Attend Our Virtual Job Fair

10% Discounted Global Certification

Course completion certificate and Global Certifications are part of our all Master Program

Like the Curriculum ? Let's Get Started

Global Certification

Radical Technologies is the leading IT certification institute in Bangalore, offering a wide range of globally recognized certifications across various domains. With expert trainers and comprehensive course materials, it ensures that students gain in-depth knowledge and hands-on experience to excel in their careers. The institute’s certification programs are tailored to meet industry standards, helping professionals enhance their skillsets and boost their career prospects. From cloud technologies to data science, Radical Technologies covers it all, empowering individuals to stay ahead in the ever-evolving tech landscape. Achieve your professional goals with certifications that matter.

Discount Voucher

"Register Now to Secure Your Spot in Our Featured Course !"

BOOK HERE

career services

Job Assistance
Interview Preparation
Profile Buliding

At Radical Technologies, we are committed to your success beyond the classroom. Our 100% Job Assistance program ensures that you are not only equipped with industry-relevant skills but also guided through the job placement process. With personalized resume building, interview preparation, and access to our extensive network of hiring partners, we help you take the next step confidently into your IT career. Join us and let your journey to a successful future begin with the right support.

At Radical Technologies, we ensure you’re ready to shine in any interview. Our comprehensive Interview Preparation program includes mock interviews, expert feedback, and tailored coaching sessions to build your confidence. Learn how to effectively communicate your skills, handle technical questions, and make a lasting impression on potential employers. With our guidance, you’ll walk into your interviews prepared and poised for success.

At Radical Technologies, we believe that a strong professional profile is key to standing out in the competitive IT industry. Our Profile Building services are designed to highlight your unique skills and experiences, crafting a resume and LinkedIn profile that resonate with employers. From tailored advice on showcasing your strengths to tips on optimizing your online presence, we provide the tools you need to make a lasting impression. Let us help you build a profile that opens doors to your dream career.

Radical Learning Eco-System

Exam simulator

Cloud SandBox

Hands - on Cloud Lab

Developer Coding Ground

Testimonials

Play

Our Alumni

Online Batches Available for the Areas

IBM i (AS/400) Course Certification With Training In Bangalore

Q: IBM i / AS/400 Fundamentals

IBM i Introduction • What is AS/400? • Evolution: AS/400 → iSeries → System i → IBM i • IBM Power Systems • IBM i operating system • IBM i architecture • Integrated database concept • Single-level storage • Objects and libraries • Jobs and subsystems • Work management • IBM i application ecosystem IBM i Objects • Libraries • Objects • Source physical files • Physical files • Logical files • Program objects • Module objects • Service programs • Job queues • Output queues • User profiles

Q: Module 3 — CL Programming

CL Fundamentals • Introduction to Control Language • CL commands • CL programs • Variables • Parameters • Conditional processing • Loops • Program calls • Message handling • Error handling Advanced CL • CLLE • Command parameters • RTV commands • DCL • CHGVAR • IF/ELSE • DO loops • MONMSG • SNDPGMMSG • CALL • SBMJOB • Data areas • Data queues • Automated batch processing

Q: Module 4 — RPG Programming

RPG Fundamentals • Introduction to RPG • RPG history • RPGLE • RPG program structure • Free-form RPG • Variables • Data types • Expressions • Operators • Conditional statements • Loops • Procedures • Subprocedures • Parameters • Arrays • Data structures Modern Free-Form RPG • Fully free-form RPG • Control options • File declarations • Variable declarations • Procedures • Built-in functions • Error handling • Modular programming

Q: Module 6 — Db2 for i & SQL

Database Fundamentals • Db2 for i architecture • Tables • Views • Indexes • Constraints • Primary keys • Foreign keys • Referential integrity SQL • SELECT • INSERT • UPDATE • DELETE • JOIN • Subqueries • CTEs • Aggregations • GROUP BY • HAVING • CASE • Window functions Advanced Db2 • Stored procedures • Functions • Triggers • Views • Indexing • Query optimization • SQL performance analysis

At Radical Technologies, we are committed to providing world-class Azure Data Engineer Training in Bangalore, helping aspiring data professionals master the skills needed to excel in the rapidly growing field of cloud data engineering. As the leading institute for Azure Data Engineer Course In Bangalore, we offer comprehensive, hands-on training designed to meet the demands of today’s data-driven organizations.

Our Azure Data Engineer Training Bangalore program covers every aspect of the Azure Data Engineer Syllabus, ensuring that students receive in-depth knowledge of data architecture, data processing, and data storage on Microsoft Azure. Whether you prefer attending classes in-person or via Azure Data Engineer Online Training, Radical Technologies provides flexible learning options to suit your needs.

Our Azure Data Engineering Training is renowned for its practical, real-world approach. Students have access to an industry-leading Azure Data Engineer Bootcamp, which combines theory and hands-on labs to ensure they are fully prepared for their certification exams. The Microsoft Azure Data Engineer Training is tailored to cover all key topics, from data integration to security, and is led by experienced professionals who are experts in their field.

For professionals and organizations seeking Azure Data Engineering Corporate Training, we offer tailored courses that address specific business needs. Our Azure Data Engineering Corporate Training Course ensures that teams gain practical experience in building scalable, secure, and efficient data solutions on Azure.

At Radical Technologies, our Azure Data Engineer Courses are structured to ensure that both beginners and experienced professionals alike can enhance their knowledge. The Azure Data Engineer Certification Training offered here equips students with the skills and credentials needed to stand out in a competitive job market.

Our institute also offers the Azure Data Engineer Full Course, which provides a comprehensive pathway for mastering Azure Data Engineering concepts and techniques. We take pride in being one of the top Azure Data Engineer Institutes in Bangalore, with a proven track record of helping students achieve their Azure Data Engineering Certification.

Whether you are looking for Azure Data Engineer Training Online or prefer our in-person classes in Bangalore, Radical Technologies is your trusted partner for career advancement in data engineering. Join us today to enroll in the Best Azure Data Engineer Course and kick-start your journey towards becoming a certified data engineer.