Expandable subfile in as400 software

Convert loadall subfile to expandable subfile enter and. In expandable subfile after page up if we press enter, then the page that is. Convert loadall subfile to expandable subfile in just a few code changes in loadall subfile program and dspf enter and. Redisplaying the first page of a subfile is a major annoyance to users. August 1992 we begin examining the coding of the display file and hll program along with the logic and structure of typical subfile programs. The company is a subsidiary of a german parent and, rather helpfully, the software is in german. Introduction to subfiles by kevin vandever the code for this article is available for download. In an allatonce sfllen sflpagsubfile, there is a hard limit of 9999 records, though it can be set smaller with the sfllen dds keyword. If the cursor is not positioned in a subfile, the function key affects the upper subfile. Over the past two decades, thousands of commercialquality applications, programs and. Can more than one subfile record be displayed on one line. Message subfile is special file contains multiple messages taken from program message queue and placed in message sub. A new client has accounting software at least thats what it seems to be which they call as400.

An expandable subfile is one in which ideally one page of records are loaded at a time. Also, in a single page subfile both rollup and rolldown keywords must be defined in the dds of the subfile control format. How to create basic load all subfile in as400 ibm i. This view explains the basic steps to create your first load all sub file in as400 ibm i. 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. This keyword is used at file or record level to control the roll down and roll up activity for the subfile. Subfile record format a subfile s process can be divided mainly into 3 parts.

If you want to use an expanding subfile subfile size subfile page or a page at. Initially, we have a loadall subfile code and then we convert that to the expandable subfile code. This is because the rollup and rolldown activities are handled by the. Subsequent pages are added to the subfile as per the user demand. For example, sflsiz 10 and sflpag9, then 10 records from written the sub. Basically, it is a technique for loading a list of records, displaying the list, and then processing selections from the list.

Actually the question is regarding displaying more than 1 records of a pf in a single line. Progen plus is the proven, affordable and easytouse iseriesas400 application generator and report writer. In load all subfile if we press the page up or page down key the control will not go to the program and the o. Posts about iseries subfile programming written by ben. If there are no records to display on the subfile, we simply turn this indicator off so that the subfile is not displayed. In the expandable subfile the subfile size must be at least one greater than the page size. Basic coding figure 2 display file xrd002df a dspsiz24 80 ds3 a refcustmst a print a ca0303 a ca1212 a r detail sfl a select 1a i 12 6 a csnum r o. This is the full source code for the subfile sort program that appeared in the may 2004 issue of the iseries extra newsletter. Its very simple to convert your loadall subfile to the expandable subfile. As400 duplicate fileds name different types in logical file. Subsequent pages are added to the subfile as per the. Bosanova web jadvantage is a hosttoweb solution with all the benefits of a tn5250. This keyword is used with the option indicator to control the display. Whats the difference between the three types of subfiles.

U sfldsp this keyword is used at record level to display the subfile. The rolldown keyword is the same as the pageup keyword. Sorting data is something rpg programs often need to do. Ibm i application generator and report writer bcd software. Sflrcdnbr subfile record number keyword for display files ibm. Subfile screen limitatio solutions experts exchange. Expandableelasticgrowing in this case sflsiz should be grater at least by 1 than sflpag. The code accompanying this article is available for download here. Welcome to iexl software iexl is the main product site of idata development limited for its iexl product the iexl product makes the generation of excel spreadsheets from the as400. 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. Bosanova web jadvantage as400iseries webfacing software. If so you likely wont be able to jump ship to any new system without a huge software rebuild basically building your custom order taking program from scratch or switching to competitors order entry.

This newsletter normally covers cuttingedge technology, but every once in a while, either. Because, in the case of loadall subfile, system take care the pageup and pagedown request for up to 9999. To take advantage of these control fields for new subfile programming, in addition to other fields. The as400 software will only run on an as400 computer.

In this example, either the program or the workstation user can set the value of. Btw do you think someone wants to scroll more than 9999 records. For this simple subfile program, you must be able to. We cant display the 0 records in a subfile by using loadall.

This blog talks about the expandable subfile in rpg as400. I have written the below expandable subfile program where there seems to be an issue that. To share the open data path by various programs in a same job. Converting loadall subfile to expandable subfile for rpg. As400 is a virtual machine architecture, and the physical machine underneath has been radically changed a few times, without affecting the programs running in the as400 virtual. Even if there are 20 subfile rows on a screen, he needs to page around 500 times to reach the end. Rather than go into a long and involved explanation here, i will point you to a number of articles on the subject by kevin vandever. The ile rpg program to process an expandable subfile has typically the following flow. State code subfile lookup al alabama ak alaska az arizona ar arkansas ca california co colorado ct.

Sfldrop can be specified on the same subfilecontrol record format as the sflfold keyword. The source for the display file and the product file used in the example follow the. Back to basics introduction to subfiles back to basics. This file is a millionplus file of cities of the world it is easily obtained on the internet. Foundation figure 1 state code subfile lookup figure 1. Allatonce subfiles are loaded in a single pass, and the system. But unlike single page the buffer is not cleared before writing the new data.

For over 30 years, acom has developed solutions that improve the design format, output and distribution of ibm i business documents. The sflcsrrrn keyword loads a fivedigit hidden field with the relative. This example is for a load all subfile subfile size 9999. Last month, we covered three methods for processing subfiles. In expandable subfile after page up if we press enter, then the page that is displayed on the screen is that we had at our last pagedown. Youll need to use two keywords in the subfile control format. Input data from the dspf will not be transmitted to the program. For ex a pf has fields named as iden,addr whose total. Find answers to as400 subfile rolling back to page one when page down pressed after bottom displayed. How to position a particular subfile record as the first record displayed at the top. In your rpglerpgiv program you have to move a value into the. Basic coding figure 5 rpg program code indicator usage. Displaying the data from subfile buffer to the display device.

A subfile is the as400 equivalent to windows list boxes. If you really need to display more than 9999 records in an subfile, you need to write a page at time subfile, i. Introduction to subfiles ibm rpg computer program scribd. Hi stiju, the input subfile is coded same as normal subfile you may design your subfile with input capable fields may be size greater than page. Single page subfiles nick litten is ibmi, as400 iseries. You use this fieldlevel keyword on the subfilecontrol record format to specify. The subfile record is very simple with just four fields. We assign a response indicator with this keyword and handle the activity with these indicators. The questioner must be asking about a expanding or a load all type of. As400 subfile rolling back to page one when page down. If its just a simple single field array youre sorting in order. This is the rpg programming on the as400 iseries rpg400l mailing list to post a message email. The dds for the cities file used in this application note. The rollup keyword is the same as the pagedown keyword.