RPG SQL: load all subfile has fixed maximum size of 9999 records

  • Home
  • /
  • Blog
  • /
  • RPG SQL: load all subfile has fixed maximum size of 9999 records

October 10, 2006

RPG SQL: load all subfile has fixed maximum size of 9999 records

By NickLitten

October 10, 2006

RPG, code, example, sample, subfile

What is a load all subfile?

A load all subfile is one in which we generally specify the subfile size as 9999 in the record format itself. However, you may define the subfile size to be less than 9999 in the record format and still load all your subfile at a time. In that situation the records will not be placed at contiguous memory location.

So, conceptually a load all subfile is the one in which all records are loaded at one go before they are displayed. Also, they should occupy contiguous memory locations.

Load all subfiles are the easiest concept in subfile. That too when the subfile is display only!

Let’s see the example of a load all subfile DDS in the free lesson section:

RPG SQL: load all subfile has fixed maximum size of 9999 records 1

Example Load All Subfile in SQL RPGLE

RPG Programming for Beginners

RPG is the well known programming language on the IBM i platform. Earlier versions of RPG ran on the old AS/400 and iSeries machines in decades gone by… the beauty of RPG is that it is fully backwards compatible. But, over the years RPG has evolved massively!

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Join the IBM i Community for FREE Presentations, Lessons, Hints and Tips

>