I do this because not all of you readers are seasoned veterans. Subfile is a group of records of same record format and can be read from or write to the display in a single operation. As400 interview questions and answers from realtime interviews. Right click or from the select action menu, select export as and pdf using infoprint server. As400 reports if this is your first visit, be sure to check out the faq by clicking the link above. Creating a subfile profound logic documentation profound logic. The reason that you are having the problem is because the program is using rrn field as relative record of subfile sfileformat. To see which record was selected, i added the subroutine selrcd after the exfmt operation. The rpg programs workstn fspecs define the subfiles relative record number field. Flat file processing in rpg program in as400 create flat files in. Thanks bryce martin programmeranalyst i 5705464777 jerry c. Display file dspf basics for beginners as400 ibm i youtube. Sflmsg subfile message and sflmsgid subfile message identifier keywords for display files you use these recordlevel keywords on the subfile control record format to identify a message to be displayed on the message line when your program performs an output operation to the subfile control record format. Basically, it is a technique for loading a list of records, displaying the list, and then processing selections from the list.
A subfile driven by podge can be written in as little as 10 seconds. After clearing the subfile buffer, records equal to the size of sflpag is written. Subfile record format, subfile control record format, relative record number, subfile record number, associated subfile keywords. I was writing a footer before exfmt of the control record. Subfile record format a subfile s process can be divided mainly into 3 parts. Open windows explorer and open the folder where you wish to copy the file to, this could be your pc or. Controlling subfiles there are several areas of programming which make up a successful subfile program.
Laying the foundation for subfile usage requires familiarization with underlying concepts and basic definitions. Sfldrop can be specified on the same subfilecontrol record format as the sflfold keyword. Rpgiv template documentation prodata computer services. When i run the runqry command, line 2, no spool file is produced. Spoolflex edelivery suite allows companies to convert spool files to as400 excel xls and xlsx automatically. You cannot declare more than one object file in a cl programme.
Introduction to subfiles by kevin vandever the code for this article is available for download. When you read the subfile record, the system change the rrn to t. The cobol subfile programming iscbs course is the follow on to. Rpg subfiles pdf this next technique came to me when i was asked to create a subfile applica tion that works. Sflctl subfile control sflsiz subfile size sflpag subfile page size sfldsp subfile display activation.
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. In this example i will save it to the document test. Subfile screen limitatio solutions experts exchange. Clear the sub file load the subfile display the subfile. Go back to the as400 operations navigator windowor start it now.
If both keywords are active, the sflfold keyword is used. As400 reports distribution converts to pdf excel and email. It should not be used for anything other than for that purpose. August 1992 we begin examining the coding of the display file and hll program along with the logic and structure of typical subfile programs. What is the maximum number of records you can specify in a display file.
Sorting data is something rpg programs often need to do. The code accompanying this article is available for download here. The following is an rpg subfile example with a selection option. July 1992 complete understanding of any subject begins with a starting point to build upon. Pdf document contains command syntax for using podge also included in the binaries file. Sflmsg subfile message and sflmsgid subfile message identifier keywords for display files you use these recordlevel keywords on the subfilecontrol record format to identify a message to be displayed on the message line when your program performs an. Every time the record is written in the buffer, buffer is cleared before writing. Indicators are checked at the time the subfile is displayed. Use screen design aid to create and maintain display files that contain subfiles. If the cursor is not located on a subfile record, this field is zero.
A subfile is the as400 equivalent to windows list boxes. Use the concept of subfile to display more than one record, but a single output message subfile is a special type of subfile that is supported well in cl. What is the select and omit criteria in logical file. Delegates should ideally have attended the system facilities course issfc and program design ispgd prior to this course or have hands on experience of using pdm, seu, sda and dds. I have also included a heading for it in the subfile control record. Cpd7812 subfile control record overlaps subfile record from the expert community at experts exchange. Now, this popular manual has been updated from beginning to end to teach subfile concepts and programming techniques using freeformat rpg. 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.
However, rather than specify the window attributes with this keyword, ive specified that display management should reference format window1 making rcdctl a window reference format when displaying. Acb4 description iseries as400 cobol subfile programming is a selfpaced, multimedia course providing comprehensive, practical training in the design and coding of subfile programs. Youll need to use two keywords in the subfile control format. Need to create excel, csv, html, json, pdf, spool reports. These spooledfiles are converted to pdf and other file formats, including ms excel. The overlay keyword is the primary method of putting one record format on the screen while leaving other information on the screen.
The dds for the cities file used in this application note. Work stations customization object, wscst, must be pdf. As400 form overlay iseries as400 print afp spool file to. Way to get the same results using rpg and subfile processing. Rcdctl is the format used as the subfile control format for subfile rcdsfl, and it appears next. The subfile first of all loads the data in subfile buffer. Once i added the overlay to the footer it worked fine. Subfile command links will go to the ibm site for a more detail definition.
Subfile relative record number, page size and page. System i as400, iseries, i5 rpg400 programming sierra it. Special names in cobol debugging cobol programs creating a subfile display subfile programming types and techniques coding a load all subfile program validation and file maintenance file maintenance program handling record locks. As400 load all subfile computer data data management. Some are new to the industry and want to see more basic. As a prelude to the specific code used to implement a subfile. This field is initialized with zero and are referenced by the workstn file using filesf01sf. Best practice for displaying an empty subfile ahh yes. Indicators allow us to manipulate the status of the subfile from the rpg code. Reports and spool files can be distributed in many popular formats such as pdf, excel, html, csv, rtf or txt without programming. How do i call an as400 program from command prompt of windows. It takes less than 20 seconds to write complete subfile code.
In that case its an allatonce sflsiz sflpagsubfile, that means that the program is continuing filling the subfile until the end of file situation is reached. The article uses an example of a subfile with position to capability and presents the techniques and logic changes required to code a modified loadall, expanding or page. Convert report to as400 excel pdf and email or place on. A subfile with paging by ibm i and highlevel language. The sflcsrrrn keyword loads a fivedigit hidden field with the relative record number of the subfile record upon which the cursor is located.
Convert report to as400 excel pdf and email or place on file. You use this recordlevel keyword on the subfilecontrol record format to assign a command attention ca key or a command function cf key that the workstation user can press to fold or truncate subfile records that require more than one display line. To start viewing messages, select the forum that you want to visit from the selection below. Jun 18, 2016 this utility can write subfile code for any given sql select statement with little or no user interaction. The source for the display file and the product file used in the example follow the rpg source. Back to basics introduction to subfiles back to basics. 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.
I have added the field, sel, to the subfile data record. For this simple subfile program, you must be able to. Of course, you could group two subfields together if they happen to be adjacent in the subfile record. To convert a spooled file to a pdf file, follow these steps. A single page subfile is a screen of displayed data loaded at a one time in one go. Now, when a user keys an x on a line and hits enter, the subroutine can determine which record was selected. Write complete subfile code in less than 20 seconds. Pdf files produced by pdfing may be saved to specified storagelocations, printed or sent as email attachments to selected recipients. Sfldrop can be specified on the same subfile control record format as the sflfold keyword. In this case sub file size sflsiz must be equal to subfile page sflpag. When the subfile is cleared, s1rrn should be reset to zero. So if you set the sflsizsflpag then the maximum number of subfiel records is fixed. This gives me the option to flip to the other mode somewhere in between.
Redisplaying the first page of a subfile is a major annoyance to users. The following screen is an example of the subfile maintenance multiple entry. System i as400, iseries, i5 rpg400 programming sierra. Displaying the data from subfile buffer to the display device. 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. In the program logic, there are certain principles that govern the type of logic required. In that case its an allatonce sflsiz sflpag subfile, that means that the program is continuing filling the subfile until the end of file situation is reached. But the real fun begins when you combine the features. You should be able to employ this to combine top and bottom formats, overlayed by a format in the subfile in middle, if you wish. As400 operations navigator or ibm iseries access iseries.
If the cursor is not positioned in a subfile, the function key affects the upper subfile. Cl programs or any iseries ile program can generate interactive subfile displays using podge. Reports and spool files can easily be distributed to email inbox, printer or posted to file server for easy retrieval. This technique is very simple and in most cases quite a fast way to sort subfile data or any other kind of repeating data. Affordable easytouse very fast sbtn3812scs2pdfspmd complimentary free software. This article examines the coding required to write effective subfiles and present them onscreen without clearing the lines behind the subfile. 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. A subfile is nothing but just displaying records in tabular format on a display device. There are ddsspecifications which define certain keywords to govern page initialization and positioning. This video explains the basic concepts of display file dspf in as400 for our beginners by developing a mini calculator application. This utility can write subfile code for any given sql select statement with little or no user interaction. For a zip file containing all the sources, click here. On their own, each feature is simple to code in an. To display the subfile contents to the user, you write the records to be displayed into the subfile records, set the proper indicators and write the control record format to display them to the user.
Subfile help needed midrange news for the ibm i community. How to create and deliver excel reports from ibm i as400 as400 database andor spool file. Adams iseries as400 operations command guide page 17 of 30 work with system statuswrksyssts view system activity and status continued after pressing enter, the screen below is displayed. During the course multiple screen enquiry, reporting, and maintenance programs will be designed, developed and linked together. System i as400, iseries, i5 cobol programming sierra. On the line that shows the as400 operations navigator you will see a gray box with a check mark.
Best practice for displaying an empty subfile rpg400l. Depending upon your level of expertise, you can do. The displayed data is equal to the maximum number of records which can be displayed at a time. Spoolflex easily bursts, converts and distributes any as400 spool file report. Or it could say ibm iseries access then iseries navigator. All you have to do is define the data structure and pick up the value right after the exfmt. For example, you can only sort on one subfield at a time.
Select the printer output file that you want to convert. Dec 05, 2010 subfile relative record number s1rrn s1rrn is defined on the fspec for the workstn file to assign the files rrn field. Oct 01, 2002 rcdctl is the format used as the subfile control format for subfile rcdsfl, and it appears next. Spoolflex easily transforms almost any spool file on any power system running ibm i, iseries or as400 to many popular pc file formats including microsofts excel both xls and xlsx without manually converting or rekeying information. 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. Is it possible to stick a display file record format into the. Check video at topbottom of this page for more details. Ive never seen or can i find an example of doing this on the web.
To be a real pro, you need to handle them properly. Pdfing runs on a microsoft windows pc and receives spooledfiles sent to it by standard os400 and i5os commands. Generally, i set it again just before the exfmt sflctl. The control format may have information of its own to display to the user e. Custr name, first, f4 for list f3exit f4prompt f5report f9add file. There are any number of ways to build and maintain them. Is it possible to stick a display file record format into. This file is a millionplus file of cities of the world it is easily obtained on the internet.
Sflmsg subfile message and sflmsgid subfile message. To add fields to the subfile, drag and drop other widgets into the first row of the subfile and then bind them to rpg fields. In other words in a single page subfile all loaded records are displayed at a time. To stream file, tostmf, contains the folder and file name i wish to save the spooled file to. Reports and spool files can easily be distributed to email inbox, printer or posted to file server. Basic coding figure 5 rpg program code indicator usage.
The programs first task is to load the subfile with one page of records in this case, nine. Subfile processing is an integral part of rpgiv data entry and data display. After far as subfile displays go, it is standard practice to have a separate format for the footer which you write first. The work with system status display shows a group of statistics that depicts the current status of the system. What are the two record formats that a subfile contains. To view or download the pdf version of this document, select dds concepts about 1170 kb. This is the full source code for the subfile sort program that appeared in the may 2004 issue of the iseries extra newsletter.