METROPOLITAN COMMUNITY COLLEGE
COURSE TITLE IBM iSeries RPG Programming II
COURSE PREFIX AND NO. INFO 1535 LEC 4 LAB 1.5 CREDIT HOURS 4.5
This course teaches the student how to use AS/400 RPG advanced programming features. The course
includes interactive processing, DDS creations for display files, RPG data structures, data areas, DDS
for printer files, printer file processing and error handling procedures.
This course is a continuation of INFO 1525. In this course the student will learn and practice
interactive programming for online systems, different methods of exception handling, and other
advanced topics. This course will prepare the student for a programming job on the AS/400.
REQUIRED TEXTBOOK (S) and/or MATERIALS:
Title: Programming in RPG IV
Publisher: Duke Communications
Attached course outline written by: Ted Tucker Date: 10/95
Reviewed/Revised by: Ted Tucker Date: 8/04
Effective quarter of course outline: 05/FA
Academic Dean: Thos C. Pensabene Date:
Metro Community College Page 1 of 4 Revised: Aug-05
COURSE OBJECTIVES/TOPICAL UNIT OUTLINE/UNIT OBJECTIVES
TITLE: IBM iSeries RPG Programming II PREFIX/NO.: INFO 1535
Upon successful completion of this course, the student will be able to do the following:
1. Describe how to process multiple data files in an RPG/400 program.
2. Describe the use of WORKSTN files to communicate interactively with work station users.
3. Demonstrate how to code and interactive RPG/400 program utilizing the necessary commands.
4. Demonstrate how to code an exception error handling routine using information supplied by
program and file information data structures.
5. Define subfile according to the AS/400 system operating procedures.
6. Describe and demonstrate the use of subfiles in a RPG/400 program.
TOPICAL UNIT OUTLINE/UNIT OBJECTIVES:
UNIT I. FILE PROCESSING
A. Explain how RPG/400 supports full procedural file processing.
B. Explain how database files allow RPG/400 programs to access the file utilizing the
operating system services.
C. Describe the use of physical files and logical files in a RPG/400 program.
D. Demonstrate how to code a RPG/400 program utilizing join logical files.
E. Describe how RPG/400 programs can process database files utilizing the "access path
describe" for the data base files.
UNIT II. WORKSTATION FILES
A. Describe how the WORKSTATION file allows a RPG/400 program to communicate
interactively with a work station user.
B. Demonstrate how a RPG/400 WORKSTATION may use an externally described
display device file.
C. Describe how display file are created by using SDA (Screen Design Aid).
D. Demonstrate how a RPG/400 program utilizes display files to display data on the
workstation from a database file.
Metro Community College Page 2 of 4 Revised: Aug-05
UNIT III. INTERACTIVE RPG
A. Differentiate between batch programming and interactive programming on the AS/400.
B. Describe the RPG/400 instructions used to interface with the display file.
C. Describe the use of indicators in an interactive RPG/400 program and how they improve
the communication between the user and the workstation.
D. Demonstrate the use of interactive RPG/400 program to perform maintenance on a
UNIT IV. EXCEPTION/ERROR HANDLING
A. Describe the operations that can cause a file status error to occur in a RPG/400 program.
B. Describe the information data structure (INFDS) and how the RPG/400 compiler
initialized it with file-related status information.
C. Describe the program status data structure (PSDS) and what information it contains
about the program being run and exception/errors that may occur.
D. Describe the special exception/error subroutine *PSSR (program status subroutine) and
how it can be utilized in a RPG/400 program to trap all unchecked error conditions.
UNIT V. SUBFILE:INTRODUCTION AND BASIC FEATURES
A. Describe the basic concepts of how a subfile works in a RPG/400 program.
B. Describe the difference between a subfile and a database file.
C. Describe how programmers can use subfile to provide search and select inquires over all
the files on the system.
D. Describe how programmers process a subfile as if they were processing a database file.
UNIT VI. SUBFILE - PROGRAM OPERATION
A. Describe the basic operations used to process a subfile in a RPG/400 program.
B. Describe how an I/O request from a program subfile record format is processed by the
program and the operating system.
C. Describe how a subfile can be used to add, change, and delete records in the database
file via your computer program.
D. Describe how you must specify the size of the subfile and the number of subfile records
to be displayed at one time.
UNIT VII. TIPS AND TECHNIQUES
A. Define what a data structure is and how it can be utilized in a RPG/400 program.
B. Demonstrate the use of a multiple occurrence data structure in RPG/400 program.
C. Describe how the RPG/400 auto report function is utilized in a RPG/400 program.
D. Explain how the different programming aids such as Screen Design Aid, can be utilized
in creating an interactive RPG/400 program.
Metro Community College Page 3 of 4 Revised: Aug-05
Upon successful completion of this course, the student will learn and practice interactive programming
for online systems, different methods of exception handling, and other advanced topics.
This course requires students to work an average of 1.5 hours per week in hands-on, lab activity.
Students are responsible for completing all lab work outside of the classroom. While you may choose
to do this lab work someplace other than the College, Metro provides computer labs for students who
do not have the required resources or facilities available to them.
1. Describe how to process multiple data files in an Multiple File Program
RPG/400 program. Assignment
2. Describe the use of WORKSTN files to communicate Display File Exercise
interactively with work station users.
Objective 1 - 2 Test
3. Demonstrate how to code an interactive RPG/400 Programming Assignment
program utilizing the necessary commands.
4. Demonstrate how to code an exception error handling Error Handling Program
routine using information supplied by program and file Assignment
information data structures.
5. Define subfiles according to the IBM AS/400 system Simple Subfile Program
6. Describe and demonstrate the use of subfile in a Subfile Program
RPG/400 program. assignment
Objective 1-8 Final examination
Metro Community College Page 4 of 4 Revised: Aug-05