EIEIOTECHNOVATION
← Training programmes

EIEIO / AUTOMATION & EMERGING TECHNOLOGY

IBM System i Programmer Training

Course outline

10 days
Discuss this programme →

Duration

10 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

9:00am-10:30am

  • Introduction to IBM System i.
  • Accessing IBM System i using IBM i Access for Windows.

10:30am-10:45am Morning break

10:45am-12:30pm

  • Commands and menus in IBM System i.
  • Customization of keyboard and screen color setting.
  • Introduction to IBM System i File Structure

12:30pm-1:30pm Lunch

1:30pm-3:30pm

  • Introduction to Library List
  • Introduction to Message Queue
  • Introduction to Programming Development Manager (PDM)

3:30pm-3:45pm Afternoon break

3:45pm-5:00pm

  • Creating Source Physical File
  • Introduction to Source Entry Utility (SEU)
  • Introduction to Physical File (PF)
  • Introduction to Data File Utility (DFU)

Day 2

9:00am-10:30am

  • Introduction to Logical File (LF)
  • Creating Data File backup

10:30am-10:45am Morning break

10:45am-12:30pm

  • Reorganization of Physical File

12:30pm-1:30pm Lunch

1:30pm-3:30pm

  • Introduction to Screen Design Aid (SDA)
  • Creating Screen & Menu.

3:30pm-3:45pm Afternoon break

3:45pm-5:00pm

  • Overview of Program Compilation Listing

Day 3

9:00am-10:30am

  • Introduction to RPG ILE.
  • RPG ILE Program Specification

10:30am-10:45am Morning break

10:45am-12:30pm

  • Overview of Operation codes

12:30pm-1:30pm Lunch

1:30pm-3:30pm

  • Arithmetic Operation in RPG ILE
  • Selection & looping

3:30pm-3:45pm Afternoon break

3:45pm-5:00pm

  • Usage of Subroutine
  • Usage of Indicators

Day 4

9:00am-10:30am

  • Handling Database File Operation in RPG ILE

10:30am-10:45am Morning break

10:45am-12:30pm

  • Creating Database File Maintenance Program with functions of add, edit, display and delete record.

12:30pm-1:30pm Lunch

1:30pm-3:30pm

  • Introduction to Program Debugging

3:30pm-3:45pm Afternoon break

3:45pm-5:00pm

  • Revision

Day 5

9:00am-10:30am

  • Introduction to Array: Types and Operation

10:30am-10:45am Morning break

10:45am-12:30pm

  • Introduction to Table

12:30pm-1:30pm Lunch

1:30pm-3:30pm

  • Introduction to Data Structure: Types and Operation

3:30pm-3:45pm Afternoon break

3:45pm-5:00pm

  • Creating Sub program and parameter list

Day 6

9:00am-10:30am

  • Introduction to Report Layout Utility (RLU)

10:30am-10:45am Morning break

10:45am-12:30pm

  • Designing report and Printer File creation

12:30pm-1:30pm Lunch

1:30pm-3:30pm

  • Develop Reporting program

3:30pm-3:45pm Afternoon break

3:45pm-5:00pm

  • Introduction to RPG ILE Built-in function
  • Usage of Date and Time format and operation.

Day 7

9:00am-10:30am

  • Introduction to Sub file

10:30am-10:45am Morning break

10:45am-12:30pm

  • Designing Sub File using SDA

12:30pm-1:30pm Lunch

1:30pm-3:30pm

  • Developing Database File maintenance program using Sub File

3:30pm-3:45pm Afternoon break

3:45pm-5:00pm

  • Advanced Sub file programming techniques:

Load All

Load Partial

Record Selection

Day 8

9:00am-10:30am

  • Introduction to ILE Concept

10:30am-10:45am Morning break

10:45am-12:30pm

  • Introduction to Sub Procedure and Module Binding.

12:30pm-1:30pm Lunch

1:30pm-3:30pm

  • Introduction to Service Programs and Directory.

3:30pm-3:45pm Afternoon break

3:45pm-5:00pm

  • Introduction to Data Queue.
  • Developing RPG ILE program to handle Data Queue.

Day 9

9:00am-10:30am

  • Introduction to Control Language (CL) Program.

CL Program structure

Logical Operator

Relation Operator

Built-in Function

String concatenation

10:30am-10:45am Morning break

10:45am-12:30pm

  • Working with Message File

12:30pm-1:30pm Lunch

1:30pm-3:30pm

  • Creating subprogram

3:30pm-3:45pm Afternoon break

3:45pm-5:00pm

  • 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 10

9:00am-10:30am

  • Introduction to Query/400

10:30am-10:45am Morning break

10:45am-12:30pm

  • Define query with file selection, record selection, select & sequence field, sort field, output type to Display screen and report.

12:30pm-1:30pm Lunch

1:30pm-3:30pm

  • Define query: define result field, report column formatting, report summary functions, report break.
  • Operation code and constant in query.

3:30pm-3:45pm Afternoon break

3:45pm-5:00pm

  • Join file in query.
  • Output form as an out file.

Programme scope, delivery arrangements and suitability are confirmed during enquiry.