Home > IT Answers > AS/400 > Load Two Subfiles In a single screen
Sms121
185 pts.
 Load Two Subfiles In a single screen
AS/400 Subfiles, RPGLE, Subfile Display
Ok sir i will ask my question in detail..

There are two pf in my lib [strong]ramlib[/strong] 1)pf1 2)pf2 ,both Contais name and id with same name , i want to display these two files on single screnn with load all subfile so can u describe this answer? plz mention small code here...

 

 



Software/Hardware used:
ASKED: July 8, 2010  3:36 AM
UPDATED: July 9, 2010  1:25 PM
RELATED QUESTIONS
Answer Wiki:
Greetings, Is your question, like you have two PFs with same name and same fields, and then you want to use both the files for their records in a program? If so, then Rename the Record formats using RENAME keyword and use fields of one of the files using PREFIX keyword at file level. Regarding PF names, they can NEVER be same in one library. Hope this helps.. With Best Regards, Maliza
Last Wiki Answer Submitted:  July 8, 2010  9:31 am  by  MalizaIssac   40 pts.
All Answer Wiki Contributors:  MalizaIssac   40 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi again,

FPF1 IF E DISK RENAME(RCDFMT:RCDFMT1)
F PREFIX(A_)
FPF2 IF E DISK

Now, all PF1 fields to be used are A_FLD1, A_FLD2… and so on.
In subfile, the display fields need not be changed.

MalizaIssac
 40 pts.
 

Not clear – you asked about two subfiles on the screen at the same time, that would be one section of the screen used by one list and another section by another list.

This time it sounds more like you want to merge the data from the two physical files into one list.

You can produce one merged list with
- a logical file over both physicals
- an SQL union
- program logic selecting records from each file

Please help us understand the specs and direction.
Phil

philpl1jb
 44,070 pts.
 

i assume you know how to load up a single subfile.
Just double the code up with different format names and you’ve there….

However, if you’re asking how to join the data from the two files and display in a single subfile, I’d get you analysis pencil out if I were you.

Adamwkiuk2002
 215 pts.