Subfile Interaction with other Display Files
I am trying to write my first subfile program. I thought I could use a subfile to display a file and allow users to select a record from that file to update a field in another file. In my case I’m maintaining client data and have a file with languages (English, Spanish, etc). I would [...]

Answer Question   |  June 10, 2008  7:19 PM
AS/400, iSeries, Subfile

AS/400:- How to select records to be displayed in subfile
Dear All, Thanks to all your inputs. As some of you suggested, Earlier I have used SQLRPG & achieved the result by dynamically building the SQL Query string. but now they want to scrap the SQL because they say it’s a performance issue(i.e. it slows down the system & a over head on it). Now [...]

Answer Question   |  June 5, 2008  11:27 AM
AS/400, Subfile

RPG/400 – Window Subfile
I want to display a footer on a window subfile. I have used a window subfile which displays a list of codes. And want to have a footer on this window. For this I used a simple WINDOW having the same border formats and position as that of the Window subfile – this contains just [...]

Answer Question   |  June 4, 2008  6:30 AM
RPG, RPG/400, Subfile

RPG – Subfile – Read using RRN
Is it possible to read a subfile record if its RRN number is known? In my case, when on a subfile record, if F4 is pressed a Prompt window is displayed to list codes. When a code is selected I want this selected code to appear in my subfile record for which the F4 was [...]

Answer Question   |  May 29, 2008  9:25 AM
Relative Record Number, RRN, Subfile

RPG/400 – Subfile
How to code a ‘Position To’ functionality in a ‘Load All’ subfile? I.e Once we load all the subfile, and the element is present in the 5th page, then how to postion the display to the 5th page?

Answer Question   |  April 22, 2010  6:10 AM
RPG, Subfile

Reading Subfile
How we can read whole subfile (whether records are changed or not)?

Answer Question   |  April 21, 2010  6:20 AM
RPG, RPG ILE subprocedure, Subfile

SFL Conditioning
I have a subfile data entry screen where a user needs to enter data into several fields. There is a subroutine that checks for both entry and valid data for each field. Indicators are supposed to color, position the cursor and reverse the specific field if the field does not pass verification yet when testing, [...]

Answer Question   |  May 30, 2008  4:57 PM
SFL, SFL subfile, Subfile

AS/400:- I need to build a query to select records, to be displayed in subfile
The requirement is basically:- 1) I have a screen with some “FROM” and “TO” fields(see below:) ————————————————————————————————————– Select: From To —————————— ———– ———– Fax Referenece Number: XXXXXX XXXXXX Order date XX/XX/XX XX/XX/XX Contract number PKXXXXX PKXXXXX Item XXXXXXXXX XXXXXXXXX Warehouse XXX XXX Vendor XXXXXX XXXXXX F3 – Exit Press enter —————————————————————————————————————- all records satisfying the [...]

Answer Question   |  May 22, 2008  10:07 AM
AS/400, Subfile

Subfile whats the difference between in READC and SFLNXTCHG
Hi Friends, I am new learner of as/400. Can somebody tell me that whats diff. between in READC and SFLNXTCHG ..can somebody gv me a practical example of sflnxtchg means why and when we use this keyword…. Thanks in advance….

Answer Question   |  May 14, 2010  12:01 PM
READC, SFLNXTCHG, Subfile

single page subfile
Hello friend, Currently i m learning as/400.i am confidence when i make load all subfile and expandable subfile…but when i go for single page subfile…i always stucked….i dont understand..page up and page down subroutine…..if anybody hv full progrm for single page subfile plzz mail me…. my email id is swapnil.amit83@yahoo.com

Answer Question   |  April 29, 2008  12:39 PM
iSeries development, Subfile

Multiple Sorts Without Using Multiple Function Keys
When doing WRKACTJOB, you can put the cursor over the column you wish to sort and then press F16. I have a subfile program with multiple sorts and presently the user has to press different function keys to sort. Can anyone give me an example of the code to use so my program will act [...]

Answer Question   |  February 12, 2008  2:10 AM
RPG, RPGLE, Subfile

Clearing a subfile screen
I have a load-all subfile that offers the user an Fkey to only display records that contain a predetermined value in a specific field. Here’s the problem; If the user presses the Fkey and there are no records that contain the value required to select the record for display, I present the user with a [...]

Answer Question   |  April 20, 2012  4:36 PM
Subfile

READ FROM SUBFILE
Hi, I have a problem in reading my subfile: After loading the subfile and display that on screen, I want to read the records of subfile and write them on preint file. But inspite of managing the RRN, every CHAIN command get the last record of subfile. here is the code: C EVAL RRN = [...]

Answer Question   |  December 15, 2007  5:22 AM
CHAIN, RNN, Subfile