What is an IBM-i RPG 'EXPANDING SIZE' Subfile?

Expandable subfiles in RPGLE

In IBM i RPG programming, an Expanding Page Subfile is a type of subfile that dynamically grows as records are added, without requiring the programmer to predefine a fixed number of records per page. Unlike traditional subfiles (such as "Load-All" or "Page-at-a-Time" subfiles), an expanding page subfile loads records incrementally and expands the display as the user scrolls, making it efficient for handling large datasets.

Key Characteristics of an Expanding Page Subfile in RPG

  • Dynamic Growth: The subfile starts with an initial set of records and expands as more records are written, typically controlled by the program logic.
  • SFLSIZ > SFLPAG: In the display file (DSPF), the subfile size (SFLSIZ) is set larger than the subfile page size (SFLPAG). This allows the subfile to grow beyond the initial page size without clearing and reloading.
  • Scroll-Friendly: Users can scroll through records seamlessly, and the program adds more records to the subfile as needed, often triggered by the user reaching the bottom of the current page.
  • Efficient for Large Data: It avoids loading all records at once (unlike a Load-All subfile), making it memory-efficient and responsive.

How It Works:

The display file defines the subfile with SFLSIZ (subfile size) greater than SFLPAG (page size). For example:

A                     SFLSIZ(9999) SFLPAG(10)

Here, SFLPAG(10) means 10 records are shown per page, and SFLSIZ(9999) allows up to 9,999 records to be added dynamically.

In the RPG program, you write records to the subfile using a loop, and the system manages the display and scrolling. The program typically tracks the last record written and adds more as the user scrolls.

Example in RPG Free Format:

// Define subfile control and record formats
Dcl-F MyDspF WorkStn Sfile(SflRcd: Rrn);

// Variables
Dcl-S Rrn Zoned(4) Inz(0);

// Load initial records into subfile
For i = 1 to 20; // Example: Load 20 records initially
Rrn += 1;
Field1 = 'Record ' + %Char(i);
Write SflRcd;
EndFor;

// Display subfile
SflDspCtl = *On; // Display control record
SflDsp = *On; // Display subfile records
Write SflCtl;
Exfmt SflCtl;

// Logic to expand subfile as user scrolls can be added here

Advantages:

  • Ideal for applications where the number of records is unknown or large.
  • Reduces memory usage compared to loading all records upfront.
  • Provides a smooth user experience with scrolling.

    • Challenges:

  • Requires careful management of the relative record number (RRN) and scroll logic.
  • Debugging can be trickier if errors occur during expansion.

    • An expanding page subfile is a flexible and efficient way to handle subfile data in IBM i RPG, especially when paired with modern tools like Visual Studio Code for coding and debugging.

    Done?
     Mark lesson complete
    Previous Lesson
    Next Lesson
    {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
    >