LF over 2 look-alike PFs (different libraries)

1930 pts.
Tags:
AS/400
I'm mainly asking if this CAN be done ... I have 2 identical files in different libraries. Can I create 1 LF over them ? OK ... if so then any hints as to how ?

Software/Hardware used:
AS/400

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 5  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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • CharlieBrowne

    you need to create a Join Logical file.

    Searching the web you will find many examples. Here is a link to one of them

    http://publib.boulder.ibm.com/iseries/v5r1/ic2924/index.htm?info/dbp/rbafomst111.htm

    41,380 pointsBadges:
    report
  • TomLiotta
    What kind of LF do you want? I wouldn't think you want a JOIN LF, but maybe you do. Without knowing what the LF needs to present to any programming, there's no good way to know if it can be done. -- Tom
    125,585 pointsBadges:
    report
  • aceofdelts

    Thanks Charlie.

    My goal was "1-stop shopping" ... to go to 1 LF that would span as many as 14 libraries (1 PF per lib - they used libs to separate companies for this old app). The duplicate field names seemed to complicate my 1st try at a Join LF.

    It felt like I was going in the wrong direction. It isn't like a Header/Detail mix of related records but rather unrelated records that use the same file layout.

    I'll experiment some with the Join later, but I can get by with just 2 separate LFs because all invoicing runs through these 2. This would be SOOO clumsy if all 14 came into play.

    Thanks for the quick replies.

    1,930 pointsBadges:
    report
  • TomLiotta
    I'd think you'd want more like a UNION rather than a JOIN. I.e., it would effectively be a multi-format LF (even though the formats might be the same in all files). -- Tom
    125,585 pointsBadges:
    report
  • WilsonAlano
    Hi,

    What about multi member LF?

    One member of each PF and you can open all at once with

    OVRDBF FILE(LF1)
           MBR(*ALL)



    2,485 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following