Ibm i as400 web reports, charts and dashboards clover. In a pageatatime sfllensflpag subfile, there is no limit, since the program only populates one page at a time, and the program receives control back each time pageup or pagedown is pressed. To increase your understanding and retention of the information, all theory is backed up with easytounderstand working program examples. It includes db2, mysql and ms sql templates so you can produce professional looking reports in minutes. With the webfocus reporting server on as400 the is no longer a need to issue remote commands. I found these on an old dusty corner of my homeserver. The program is written in report program generator rpg. This newsletter normally covers cuttingedge technology, but every once in a while, either by request or by choice, i decide to write a back to basics article. Pdf files produced by pdfing may be saved to specified storagelocations, printed or sent as email attachments to selected recipients. I do this because not all of you readers are seasoned veterans. This article examines the coding required to write effective subfiles and present them onscreen without clearing the lines behind the subfile. That is a webfocus client along with a webserver, and the reporting server.
Introduction to subfiles by kevin vandever the code for this article is available for download. As400 subfile rolling back to page one when page down. The work with system status display shows a group of statistics that depicts the current status of the system. 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. A subfile is nothing but just displaying records in tabular format on a display device.
Pdf files can easily be emailed or posted directly to the ifs on the ibm i, iseries or as400 or directly to your server for easy access by end users. Display file dspf basics for beginners as400 ibm i youtube. Youll need to use two keywords in the subfile control format. Clover query is a business intelligence tool that enables users to create realtime webbased reports. Begin edit i can get the rowcol of where the user clicked on the screen just fine, my problem is when the user scrolls sflbb, sflcc or sfldd down to say the 75th subfile record and then they click on that subfile.
With subfiles, the complexities of writing online programs to manipulate data in a database are reduced. To view or download the pdf version of this document, select dds concepts about 1170 kb. What is the select and omit criteria in logical file. To do this, i need first to examine how to program subfiles. As400 reports if this is your first visit, be sure to check out the faq by clicking the link above. If that brings back the queries you are after, then do a 5 by the query to view the query definition. To start viewing messages, select the forum that you want to visit from the selection below.
Allatonce subfiles are loaded in a single pass, and the system handles the pageuppagedown keys for you. Using subfiles is an essential skill of the as400 programmer. The list of members that you can see in the pdm is an example of a subfile. Basic coding figure 5 rpg program code indicator usage. Back to basics introduction to subfiles back to basics.
Clear the subfile load the subfile display the subfile process subfile records selected by the user. 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. This keyword is used with the option indicator to control the display. This view explains the basic steps to create your first load all sub file in as400 ibm i. Subfile processing is an integral part of rpgiv data entry and data display. August 1992 we begin examining the coding of the display file and hll program along with the logic and structure. Examples from programming subfiles in cobol400 by jerry goldson, rmiklos reporting services it is free and there are some nifty utilities to build reports. If there are no records to display on the subfile, we simply turn this indicator off so that the subfile is not displayed.
Indicators allow us to manipulate the status of the subfile from the rpg code. As400 rpgle, free, sqlrpgle, clle, subfiles,ifs creating pdf and excel files. Reports and spool files can be distributed in many popular formats such as pdf, excel, html, csv, rtf or txt without programming. Subfiles for rpg programmers begins with concepts such as subfile record formats and subfile loading, then progresses to more advanced applications. Use screen design aid to create and maintain display files that contain subfiles. The dds for the cities file used in this application note.
If youve got a printed query, its probably generated by a call to runqry qryyourlibyourqry somewhere try going into wrkqry and then in the library field, put libl, then in the query field, put pbrp581 and do f4. Application developer, systems analyst, and systems manager in a small to medium business. Depending upon your level of expertise, you can do. Enjoy the trip down memory lane or to use old rpg lingo as400nerd cabeq 1 start subfiles what is a subfile. Sorting data is something rpg programs often need to do. I suspect that when you hit page down at the end, you are falling back into your reload loop and reloading the subfile.
Posts about iseries subfile programming written by ben. But the real fun begins when you combine the features. Progress kb how to implement journaling on as400 files. A subfile driven by podge can be written in as little as 10 seconds. How to create basic load all subfile in as400 ibm i. To load and display this type of subfile, follow these steps. If the first time you do a readc to the subfile to calculate the value, you should update the subfile record with the sflnextchg indicator on. 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. Hi gary, i have a screen with 3 subfiles but not in windows. This file is a millionplus file of cities of the world it is easily obtained on the internet. Ibms db2 for as400 commands allow to set journaling functions to do audit trail, forward and backward recovery for the db2 tables. The sflcsrrrn keyword loads a fivedigit hidden field with the relative record number of the subfile record upon which the cursor is located. These spooledfiles are converted to pdf and other file formats, including ms excel. 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 12 11 a csname r o 12 23 a cscrlt r o 12 56edtcde1 a r header sflctldetail a overlay a sflsiz0050 a sflpag0010 a 31 sfldsp a 32 sfldspctl a 33 sflclr a 34 sflend a 1 31work.
Remember to implement subfile processing, you must. Your first port of call for this should be the job scheduler that is built into the operating system. This file is not intended to be viewed directly using a web browser. To be a real pro, you need to handle them properly. Time reporting project summary report layout prg07rp 463 project summary report data descriptions prg07rp 464 project summary report rpg400 program prg07 468 time reporting reason code summary report layout prg08rp. If the cursor is not located on a subfile record, this field is zero. Single page subfiles nick litten is ibmi, as400 iseries. Subfiles can be processed sequentially with the read subfile next modified statement, or processed randomly by specifying a relative key value. Run the program under debug, and i think it will probably be apparent what is happening. Turn over the task of spool file management and report distribution to the users generating the reports. If i move the cursor to one of this subfiles, and then press pageup or pagedown, the subfile under the cursor scrolls.
Now, this popular manual has been updated from beginning to end to teach subfile concepts and programming techniques using freeformat rpg. Redisplaying the first page of a subfile is a major annoyance to users. Presenting rpg subfiles in html web languages programming. James pratt tupelo, mississippi professional profile. This article focuses on the typical logic flow of a subfile program, along with the coding of both. As400 job scheduler if you are looking to create jobs that you need to run at specified days or times on a regular basis on your as400 then your need to be using a job control process or a job scheduler. What is the maximum number of records you can specify in a display file. Cl programs or any iseries ile program can generate interactive subfile displays using podge. The code accompanying this article is available for download here.
Reports and spool files can easily be distributed to email inbox, printer or posted to file server for easy retrieval. Examples from programming subfiles in cobol400 by jerry. 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. A relative key is an unsigned number that can be used directly by the system to locate a record in a file. Spoolflex easily bursts, converts and distributes any as400 spool file report. 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.
The subfile first of all loads the data in subfile buffer. As400 reports distribution converts to pdf excel and email. This should list all queries beginning with pbrp581. 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. You probably have used sequential files and random access files. Subfiles are particularly useful when writing online programs which move a large amount of data between a workstation and the computer. I needed a way to combine the flexibility of the pageatatime subfile with the capability to process the changed records only when desired. Rpg subfiles pdf this next technique came to me when i was asked to create a subfile applica tion that works. Jd edwards world is written mainly in ibm rpg, cl, and sql languages and runs. I just had a brief look at this code and i think you are not using the write subfile command. Subfiles are direct access files that are similar to random access files but with a key that is the actual record number. A subfile with paging by ibm i and highlevel language. Pdf document contains command syntax for using podge also included in the binaries file.
The secret to understanding subfiles is to realize that the data is written as a direct access file. Way to get the same results using rpg and subfile processing. Subfile screen limitatio solutions experts exchange. So, to read or write records to a direct access file, you.
Twenty years ago these are the kind of things you had to know to work on the old as400 systems. On their own, each feature is simple to code in an. Looks like the value of temp should be reinitialised before processing the changes in the subfiles again and recalculating the temp value. Using progress400 dataserver it is advisable to journal all or the most important files from your database. Flat file processing in rpg program in as400 create flat files in. There are any number of ways to build and maintain them.
System i and power systems native pcl to pdf converter for spool files. This is something your program is doing, not something inherent in subfiles. Ibm native conversion eliminates the need to download to a pc or secondary server to process pdf files, thus improving security and speed of pdf document. Some are new to the industry and want to see more basic. As400 form overlay iseries as400 print afp spool file to. 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. There are several different programming techniques, but this article deals with the simplest one, the fully loaded subfile. Or if you want the webfocus reporting server olone and you can put the webfocus client on another platform like windows.
A subfile is a display file where you can place a listing of values and process changes on the list. How do i determine which subfile record the user clicked on if they click on one of the nonactive subfiles. As400 interview questions and answers from realtime interviews. Podge uses ibm iseries db2 sql and a few basic parameters to generate dynamic subfiles. A subfile is a group of records that is read from or written to a displaydevice file. The following is an rpg subfile example with a selection option. This video explains the basic concepts of display file dspf in as400 for our beginners by developing a mini calculator application. Custr name, first, f4 for list f3exit f4prompt f5report f9add file. For example, a program reads records from a database file and creates a subfile of output. Subfiles with subfiles you can create a display file with lists of items.