question based on JOIN logical file.

420 pts.
Tags:
AS/400
AS/400 logical file
I have one physical file having 4 members (multi members) inside it with account_no as key field name and one more simple physical file also has same key field name i.e. account_no.
SO MY QUESTION IS CAN WE JOIN MULTI MEMBER PF AND SIMPLE PF ? 
IF YES THEN HOW ? 
IF NO THEN WHY ?
THANKS IN ADVANCE ..........


Software/Hardware used:
SOFTWARE

Answer Wiki

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

Yes, You can Join Multi member PF with simple PF.
There will not be any difference in JOIN logical file structure.

But, Default member records will be accessed from Multi member PF.

Pradeep.

Discuss This Question: 9  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
  • anupsshelke
    can I join like this ? R REDC JFILE(PF222 PF221) J JOIN(PF222 PF221) JFLD(NAME NAME) NAME JREF(PF222 ) --------------------------------------------------------------------------------------------------------- in PF222 which is multi member (dd1, dd2) fields.... in dd1 name :- anup shital nitin deepak roll :- 01, 02, 03, 04 fields....in dd2 name :- sahu, shivaji, raje, patil roll :- 06, 07, 08, 09 and PF221 which is simple PF fields...... name :-all above address :- pune,mumbai for all pan_no. :- different for all pin_no :- different for all THEN IT WILL SHOW ALL RECORD ABOVE.. IN MY CASE IT NOT SHOW ANY RECORD ..
    420 pointsBadges:
    report
  • philpl1jb
    Confused, I am. Your latest description of PF222 with different feild names in each member doesn't sound like a Physical File at all. It sounds like a Multi-Member Logical File. When you use the command
      DSPFD PF222
    what type does it show? Phil
    49,960 pointsBadges:
    report
  • anupsshelke
    when i used dspfd on pf222 it shows dd1 dd2 as member in it because pf222 is a multi member. i know how to join 2 simple physical file. now i m trying to join simple pf and multi member. (Philpl1jb)
    420 pointsBadges:
    report
  • philpl1jb
    Not what members are in it ... what type of a file is it?
    49,960 pointsBadges:
    report
  • anupsshelke
    its is a multi member . is a pf having 2 members in it (dd1 and dd2 )
    420 pointsBadges:
    report
  • philpl1jb
    OK, not really, does it have different field names for the same columns? or different keys for the same members?
    49,960 pointsBadges:
    report
  • PGMBOB
    Different members of the same file usually share the same record name so format and field names are the same. If the format of the joined fle is similar you should be able to join them specifying the member. GoOOD lUCK
    1,085 pointsBadges:
    report
  • anupsshelke
    thanks for valuable guldens , Pradeep. Philpl1jb PGMBOB thank you .
    420 pointsBadges:
    report
  • TomLiotta
    SO MY QUESTION IS CAN WE JOIN MULTI MEMBER PF AND SIMPLE PF ? Yes, as long as you only specify a single member from the multi-member file. You can't use more than a single member from a file to join to another file. IF NO THEN WHY ? Because it will fail to create and return an error message condition. Tom
    125,585 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