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. I prefer to use chain for each rrn instead of readc. 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. They take advantage of special capabilities built into display file definitions and extensions to the hlls supported by os400. If i move the cursor to one of this subfiles, and then press pageup or pagedown, the subfile under the cursor scrolls. I would download the source code to the ifs using an rpg program, and.
A relative key is an unsigned number that can be used directly by the system to locate a record in a file. If the function keys are different, only the key specified for the most recently displayed subfile is in effect. Rpg and programming blog archive subfiles in rpgiv and me. Redisplaying the first page of a subfile is a major annoyance to users. It may be that you are confusing the relative record number rrn with the sflrcdnbr. 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.
Aug 05, 2012 interactive programs present data to the user in an organized manner. How to create basic load all subfile in as400 ibm i. Those differences are, there are no any native io operations, its just sql. Pressing the function key affects the subfile containing the cursor. 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. Hi gary, i have a screen with 3 subfiles but not in windows. 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. 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. 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. As a registered member of, youre entitled to a complimentary copy of chapter 7 of subfiles in rpg iv. Subsequent pages are added to the subfile as per the user demand.
I needed a way to combine the flexibility of the pageatatime subfile with the capability to process the changed records only when desired. 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. This subfile, like the first, is a load all subfile of 30 rows, and displays six at a time. Introduction to printer file prtf in ibm i as400 duration. July 1992 complete understanding of any subject begins with a starting point to build upon. This is the full source code for the subfile sort program that appeared in the may 2004 issue of the iseries extra newsletter. This book begins with easytounderstand explanations of subfile concepts then goes on to offer a bounty of practical examples, advanced techniques. When you add an item to this list, include a link to the free pdf. If you want to, go ahead and include your thoughts on the rpg or rpg item if you have played or used it. No around the rrn thanks, jeff davis dental network of america booth martin sent by.
A simple example of a subfile and accompanying program written in. A subfile is a group of records that is read from or written to a displaydevice file. The f5 key will be used by the rpg program to say that the user wants to reload the data from the file. A subfile is nothing but just displaying records in tabular format on a display device. How to create a subfile program without using any native i. There are two main differences in my single page subfile program than many other single page subfiles on the internet. As discussed in julys subfile foundations, subfiles enable programmers to present a panel of columnar data with minimal programming.
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. 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. May 09, 2016 the subfile record is very simple with just four fields. 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. Then you can start reading kindle books on your smartphone, tablet, or computer no kindle device required. Youll need to use two keywords in the subfile control format. There are ddsspecifications which define certain keywords to govern page initialization and positioning. If i move the cursor to one of this subfiles, and then press pageup or page. Get your kindle here, or download a free kindle reading app. 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. Using chain to access a subfile record in free format. The code accompanying this article is available for download here.
August 1992 we begin examining the coding of the display file and hll program along with the logic and structure of. I added a hidden field in the subfile record format to contain the array element the subfile record was loaded from. 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. How to create a subfile program without using any native io. The net result is that subfiles make presenting columns of information easier with. The transaction file must be an externally described file. Sorting data is something rpg programs often need to do. Subfile programming chapter objectives upon completion of this chapter, you should be able to describe what a subfile is. Rules, examples, techniques, and other cool stuff kevin. Launch of as400 bookstore where you can find ibm i as400 ebooks. Jun 05, 2015 how to display a footer in a window subfile. Roll down load the data qs before loading the subfile. Subfiles can be processed sequentially with the read subfile next modified statement, or processed randomly by specifying a relative key value. Find answers to using chain to access a subfile record in free format.
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. Subfiles programming latest final file format reserved. Now, this popular manual has been updated from beginning to end to teach subfile concepts and programming techniques using freeformat rpg. The rrn uniquely identifies each row in your subfile and should be different for ea. Rules, examples, techniques, and other cool stuff written by kevin vandever and published by mc press.
The rpg programs workstn fspecs define the subfiles relative record number field. 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. If several subfiles using sfldrop are displayed at one time, the same function key should be specified on each sfldrop keyword. Expandable subfiles in rpgle an expandable subfile is one in which ideally one page of records are loaded at a time. For example, a program reads records from a database file and creates a subfile. 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.
Single page subfiles nick litten is ibmi, as400 iseries. Nov 27, 2016 there are two main differences in my single page subfile program than many other single page subfiles on the internet. Subfiles are the as400 tool that lets you display lists of data on the screen for user interaction. There are several areas of programming which make up a successful subfile program. Essentials of subfile programming and advanced topics in rpg. Com sql embedded and variables for beginners and not. 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. Author of the definitive 2000 work subfiles in rpg iv. This book begins with easytounderstand explanations of subfile concepts then goes on to. The subfile record is very simple with just four fields. Essentials of subfile programming teaches you to design and program subfiles, offering stepbystep instructions and realworld programming exercises that build from chapter to chapter. 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.
The subfile first of all loads the data in subfile buffer. The sflcsrrrn keyword loads a fivedigit hidden field with the relative record number of the subfile record upon which the cursor is located. Error message subfile rpgle applications on the iseries. To view or download the pdf version of this document, select dds concepts about 1170 kb. Subfiles in freeformat rpg independent publishers group. If the cursor is not located on a subfile record, this field is zero. 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. 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. Clearing a subfile hi pete, incorrect record number in subfile sflrcdnbr or sflsiz field.
102 680 1086 1402 292 769 118 957 1181 766 1484 444 246 1390 537 236 503 1483 929 975 1013 1533 1437 1316 1355 715 1424 1183 103 1184 1526 410 262 1109 1504 1157 661 184 689 280 1391 801 138 594 821 491