Input and File Load Subfiles

Duration

4 to 6 hours

Overview

Audience

Personnel requiring knowledge of subfile programming.

Prerequisites

Completion of the Subfile Programming Part 1 course, and knowledge of data processing, programming concepts, and the iSeries operating system.

Objectives

After completing this course, the student will be able to:
• Recognize a Data Input subfile and a File Load subfile
• Identify the DDS used to create a Data Input subfile and a File Load subfile
• Recognize the RPG code that supports a Data Input subfile and a File Load subfile

Course Content

Input and File Load Subfiles Pretest

Description of Data Input Subfile

Examine an Example of a Data Input Subfile
Define a Data Input Subfile

Data Input Subfile Keywords

Keywords Used on the Data Input Subfile Control Format:
• SFLPAG
• SFLSIZ
• SFLINZ
• SFLEND
• SFLDSP
• SFLDSPCTL

RPG for Data Input Subfile

The RPG Code to Initialize and Display the Subfile and Process the Keyed Data

RPG and Subfile Record Number

How a Subfile is Processed Using Record Number

Description of File Load Subfile

Examine an Example of a Data Load Subfile

File Load Subfile Keywords

The Keywords Used on the File Load Subfile Control Format:
• SFLPAG
• SFLSIZ
• SFLDSP
• SFLDSPCTL
• SFLCLR
• SFLEND

RPG to Prepare Subfile

How a File Load Subfile Is Cleared of Data
Preparing a Subfile
Relative Record Number
Footer Record Format
Loading the Subfile
Clearing the Subfile

RPG to Load and Display Subfile

The RPG Code Used to Load and Display the Subfile
Loading the Subfile
Displaying the Subfile
Reloading the Subfile

Input and File Load Subfiles Mastery Test