iSeries (AS400) RPG Subfile Programming

Introduction

It is hard to imagine application development without the use of subfiles. This course provides tuition in the practical use of subfiles, and how to code them within RPG programs.

What you will learn

On completion of this course, you will be able to:

• Identify the types of subfile available, and choose the right subfile for an application.
• Code a load-all subfile.
• Code a page by page subfile.
• Code a single page subfile.
• Code a data entry subfile.
• Enhance subfile programs.
• Code a message subfile.
• Code subfiles in windows.

Who should attend

RPGIV or RPG/400 programmers developing subfile applications for use on the iSeries.

Pre-requisites

Attendees should attend the iSeries (AS400) RPGIV Programming or iSeries (AS400) RPG/400 Programming course prior to this course, and follow this with a period of practical work in RPG development, or have the equivalent practical expertise. Delegates need to have a good practical knowledge of SDA, PDM and SEU.

Follow-On

iSeries (AS400) Introduction to Embedded SQL, iSeries (AS400) RPGIV Crossover, iSeries (AS400) ILE Fundamentals and iSeries (AS/400) Introduction to Java for RPG Programmers. If you attend the advanced RPG courses you do not need to attend this course.

Course content

• The concepts of subfiles.
• Subfile record formats.
• Subfile loading techniques.
• Relative record number processing.
• Declaring a display file to use a subfile.
• The subfile record and subfile control record.
• Keywords on the subfile control record.
• Subfile design using SDA.
• RPG operations available for subfiles.
• The load all subfile program logic.
• Loading and processing a load all subfile.
• The expanding subfile technique.
• Coding page up and page down.
• What to do at end of file.
• Avoiding the empty roll.
• Loading and processing an expanding subfile.
• When to use single page subfiles.
• Single page subfile program logic.
• Coding subfiles in windows.
• DDS keywords for window subfiles.
• Displaying windows from a called program.
• Subfiles for data entry.
• Subfile validation and database updates.
• Reading sequentially through a subfile.
• Coding a message subfile.
• CL programs for use with message subfiles.
• Using message subfiles.

Materials

A course manual with supporting documentation is provided. Participants on this course will develop and enhance several subfile based applications, using each of the three subfile programming styles. Delegates may bring a quarter inch cartridge tape to backup the materials developed on this course for further reference.

Schedule

Top | Home

Tel: 01489 570803 | Email: training@sierra.co.uk

Sierra Training Services Limited.
P O Box 294, Sarisbury Green, Southampton, SO31 1WQ, ENGLAND.