Load by Page and Maintenance Subfiles


Duration

4 - 6 hours

Overview

Audience

Personnel requiring knowledge of Subfile Programming.

Prerequisites

Knowledge of data processing, programming concepts, and the AS/400 Operating System. Subfile Programming Courses 1 and 2.

Objectives

After completing this course, the student should be able to detail:
  • A Load by Page subfile and a File Maintenance subfile.
  • The DDS used to create a Load by Page subfile.
  • The RPG code that supports a Load by Page subfile.
  • The DDS used to create a File Maintenance subfile.
  • The RPG code that supports a File Maintenance subfile.

Course Content

Unit 1 LOAD BY PAGE AND MAINTENANCE SUBFILES PRETEST

Unit 2 DESCRIPTION OF FILE LOAD BY PAGE SUBFILE

  • Examine an Example of a File Load by Page Subfile
  • List Function
  • DDS of Subfile Formats

Unit 3 DDS FOR FILE LOAD BY PAGE SUBFILE

  • The DDS for the Subfile and Record Formats
  • Conditioning Keywords and Indicators

Unit 4 RPG FILES AND SUBROUTINES

  • Files and Subroutines Used in the Pick List/Inquiry Program
  • Supporting RPG Code

Unit 5 RPG TO LOAD SUBFILE PAGE

  • The Workings of the GETPAG Subroutine Called from *INZSR
  • Adding Records to the Subfile
  • Displaying “More...” or “Bottom”
  • Operation of an Example Subfile

Unit 6 RPG TO PROCESS SUBFILE INPUT

  • How Enter, F3, and Subfile Selections of 1 and 5 are Processed
  • Using a Loop to Process the Users Response

Unit 7 RPG TO PROCESS SUBFILE ROLLUP

  • When and How the Program Processes a Subfile Rollup Request

Unit 8 DESCRIPTION OF FILE MAINTENANCE SUBFILE

  • Examine an Example of a File Maintenance

Unit 9 DDS FOR FILE MAINTENANCE SUBFILE

  • DDS for the Display File
  • The Keywords SFLRNA, SFLNXTCHG, and SFLMSG

Unit 10 RPG TO DISPLAY AN ORDER

  • The RPG Code to Read and Display the File Maintenance Subfile
  • Flow of Control

Unit 11 RPG TO MAINTAIN ORDER LINES

  • The RPG and DDS Used to Maintain Order Details in a Subfile
  • Adding a New Item to an Order List
  • Deleting an Order Line

Unit 12 RPG TO UPDATE THE DATABASE

  • How Data is Updated on the ORDERS and LINES Files

Unit 13 LOAD BY PAGE AND MAINTENANCE SUBFILES MASTERY TEST

 
© Copyright 2007. All rights reserved. Interskill Learning, Inc.