Subsequent pages are added to the subfile as per the user demand. Sorting data is something rpg programs often need to do. Error message subfile rpgle applications on the iseries. Subfiles can be specified in the dds for a displaydevice file to allow you to handle multiple records of the same type on the display. This subfile, like the first, is a load all subfile of 30 rows, and displays six at a time.
Using chain to access a subfile record in free format. There are ddsspecifications which define certain keywords to govern page initialization and positioning. This book begins with easytounderstand explanations of subfile concepts then goes on to. It may be that you are confusing the relative record number rrn with the sflrcdnbr. May 09, 2016 the subfile record is very simple with just four fields.
Jun 05, 2015 how to display a footer in a window subfile. The rpg programs workstn fspecs define the subfiles relative record number field. Author of the definitive 2000 work subfiles in rpg iv. It can be an editable tabular format due to which it can be used in data entry screen, inquiry static screen or combination of both i. Now, this popular manual has been updated from beginning to end to teach subfile concepts and programming techniques using freeformat rpg. How to create a subfile program without using any native i. Nov 27, 2016 there are two main differences in my single page subfile program than many other single page subfiles on the internet.
If several subfiles using sfldrop are displayed at one time, the same function key should be specified on each sfldrop keyword. As discussed in julys subfile foundations, subfiles enable programmers to present a panel of columnar data with minimal programming. There is a single character field that will be used so that the user can enter a value to, for example, edit, view, delete, etc. If i move the cursor to one of this subfiles, and then press pageup or pagedown, the subfile under the cursor scrolls. Those differences are, there are no any native io operations, its just sql. Expandable subfiles in rpgle an expandable subfile is one in which ideally one page of records are loaded at a time. Find answers to using chain to access a subfile record in free format.
Subfiles are the as400 tool that lets you display lists of data on the screen for user interaction. This book begins with easytounderstand explanations of subfile concepts then goes on to offer a bounty of practical examples, advanced techniques. The sflcsrrrn keyword loads a fivedigit hidden field with the relative record number of the subfile record upon which the cursor is located. The rrn uniquely identifies each row in your subfile and should be different for ea. After this load is complete, you can display the subfile, which gives the users access to all of the subfile records by allowing them to roll backwards and forwards.
Essentials of subfile programming teaches you to design and program subfiles, offering stepbystep instructions and realworld programming exercises that build from chapter to chapter. Single page subfiles nick litten is ibmi, as400 iseries. There two steps to display the footer in a window subfile 1 first, in sda, create a footer record, regular window. Subfiles programming latest final file format reserved. This chapter, subfiles and data queues a perfect combination, looks at how to incorporate all the features in the program development manager pdm into a subfile application. July 1992 complete understanding of any subject begins with a starting point to build upon. As a prelude to the specific code used to implement a subfile, this article lays out a basic understanding of what a subfile is, how one is implemented and why subfiles exist in the first place. Com sql embedded and variables for beginners and not. Overview an updated manual for mastering subfiles a comprehensive resource that can be used by rpg programmers as they advance from basic subfile usage to more advanced programming, this manual offers concepts, explanations, and practical examples that reflect current trends. The code accompanying this article is available for download here. A relative key is an unsigned number that can be used directly by the system to locate a record in a file.
To view or download the pdf version of this document, select dds concepts about 1170 kb. A comprehensive resource that can be used by rpg programmers as they advance from basic subfile usage to more advanced programming, this manual offers concepts, explanations, and practical examples that reflect current trends. Essentials of subfile programming and advanced topics in rpg. How to create a subfile program without using any native io. I could have used the same indication to display the subfile control as i did for sfl01, but i decided that this subfile deserves its own indicators the last record format of the display file is the footer section, which i use to display the available function keys. Then you can start reading kindle books on your smartphone, tablet, or computer no kindle device required. I added a hidden field in the subfile record format to contain the array element the subfile record was loaded from.
The transaction file must be an externally described file. August 1992 we begin examining the coding of the display file and hll program along with the logic and structure of. Subfile programming chapter objectives upon completion of this chapter, you should be able to describe what a subfile is. A subfile is nothing but just displaying records in tabular format on a display device. Subfiles can be processed sequentially with the read subfile next modified statement, or processed randomly by specifying a relative key value. There are several areas of programming which make up a successful subfile program. To take advantage of these control fields for new subfile programming, in addition to other fields related to the programming logicpattern established to use these fields, the following copy member is created to be copied into all subfile programs so that they are included during the program. Youll need to use two keywords in the subfile control format. When you add an item to this list, include a link to the free pdf. Kevin vandevers subfiles in rpg iv mc press, 2000 offered easytounderstand explanations of subfile concepts plus a bounty of practical examples, advanced techniques, and other cool stuff never before seen in subfile books. I needed a way to combine the flexibility of the pageatatime subfile with the capability to process the changed records only when desired. Roll down load the data qs before loading the subfile. Hi gary, i have a screen with 3 subfiles but not in windows.
If its just a simple single field array youre sorting in order to use the much faster binary search possible with %lookup, for example, then sorta works well and is simple. A simple example of a subfile and accompanying program written in. The subfile first of all loads the data in subfile buffer. Sep 04, 2018 subfiles in rpg iv download september 4, 2018 subfiles can be specified in the dds for a displaydevice file to allow you to handle to use a subfile for a display device file in an rpg program, you must. Aug 05, 2012 deject d d recommended indicator usage for display files d d d indicator description d d 01 turns off the overlay when writing msgct d 10 subfile record dspatrhi d 20 subfile foldunfold mode d 21 subfile 1 end and enable rollup key d 22 subfile 2 end and enable rollup key d 23 subfile 3 end and enable rollup key d 24 subfile 4 end and. The net result is that subfiles make presenting columns of information easier with. A subfile is a group of records that is read from or written to a displaydevice file.
This is the full source code for the subfile sort program that appeared in the may 2004 issue of the iseries extra newsletter. Aug 05, 2012 interactive programs present data to the user in an organized manner. Rules, examples, techniques, and other cool stuff kevin. Introduction to printer file prtf in ibm i as400 duration. As a registered member of, youre entitled to a complimentary copy of chapter 7 of subfiles in rpg iv. Pressing the function key affects the subfile containing the cursor. If i use readc with sflnxtchg, i lose the ability to tell if the user did or didnt make changes, because sflnxtchg will cause unchanged records to pop up as changed. With pageatatime subfiles, you have to clear and build one new page of subfile records every time the user pages and uses a positionto field. If you want to, go ahead and include your thoughts on the rpg or rpg item if you have played or used it. Subfiles in freeformat rpg independent publishers group. Rules, examples, techniques, and other cool stuff, this updated and expanded work is brought up to the present with freeformat rpg examples and other new material. Posts about iseries subfile programming written by ben. I would download the source code to the ifs using an rpg program, and. Launch of as400 bookstore where you can find ibm i as400 ebooks.
The f5 key will be used by the rpg program to say that the user wants to reload the data from the file. Aug 21, 2003 this chapter, subfiles and data queues a perfect combination, looks at how to incorporate all the features in the program development manager pdm into a subfile application. Get your kindle here, or download a free kindle reading app. Redisplaying the first page of a subfile is a major annoyance to users. No around the rrn thanks, jeff davis dental network of america booth martin sent by. Rules, examples, techniques, and other cool stuff written by kevin vandever and published by mc press. I prefer to use chain for each rrn instead of readc. If the cursor is not located on a subfile record, this field is zero. This article focuses on the typical logic flow of a subfile program, along with the coding of both the display file and the rpg400 program to control it. Rules, examples, techniques, and other cool stuff enter your mobile number or email address below and well send you a link to download the free kindle app.
Rpg and programming blog archive subfiles in rpgiv and me. The net result is that subfiles make presenting columns of information easier with their own syntax and structure that you must understand to use subfiles effectively. If i move the cursor to one of this subfiles, and then press pageup or page. They take advantage of special capabilities built into display file definitions and extensions to the hlls supported by os400. Types of subfiles load all method expanding subfiles single page subfiles loadall method to load all of the records that you want to display into the subfile at one time. They have the additional responsibility to inform the user about the state of the data being accessed or about an event which took place when manipulating the data. If the function keys are different, only the key specified for the most recently displayed subfile is in effect. There are two main differences in my single page subfile program than many other single page subfiles on the internet.
1491 835 1098 1414 78 373 1289 556 129 1287 1348 853 579 600 141 84 1320 657 337 1082 548 723 1187 362 487 468 776 850 102 72 626 392 385 1310 1305 728 1064 679 1201 1385 1236 865 605 938