How to create a LF with multiple PF in different libraries

30 pts.
Tags:
logical file
I am trying to create a LF with multiple physical files. The physical files are in different libraries. The LF will compile, but will not create a member. How do I get this to compile with one member, same as file name?


Software/Hardware used:
as/400
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

There are 7 physical files in my one logical file.  There are 4 in one library, that compile correctly.  The other 3 are in a different library and compile correctly.  But when I put all 7 in one LF, it will not compile with a member.  I tried the OVRDBF, but it didn’t help.  Both libraries are in my library list.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Joined LF's can be a bit tricky. Not knowing what you DDS may look like, I'll provide a sample of one of ours. The problem you may be having is if the PF are in different libraries.  You may need to do a manual OVRDBF of each PF then try creating the LF again so it can find the files. If you do a DSPFD on your LF, does it show any member? If not, you can always try the ADDLFM command. 
    Here is an example where we are using 4 PF's. All the PF Are in the same library and that is in our LIBL so it compiles fine.
    A          R RF@OH                     JFILE(file1 file2 file3 file4)
    A          J                           JOIN(file1 file2)          
    A                                      JFLD(OHORD# O4ORD#)    
    A                                      JFLD(OHSUFX O4SUFX)    
    A          J                           JOIN(file1 file3)          
    A                                      JFLD(OHORD# O2ORD#)    
    A          J                           JOIN(file1 file4)         
    A                                      JFLD(OHBILL CMCUST)
    133,675 pointsBadges:
    report
  • Rita5525
    Well apparently, it makes a difference in what order you put the files in the logical.  I had the 4, from library A first, then the 3 from library B second.  It would not compile with a member.  I reversed the order and put the 3 files from library B first and it compiles correctly, with a member.  Thanks for your help.
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: