How to find the Multi Member File in As400 System?

1215 pts.
Tags:
AS/400
AS/400 file specification
Multi-Member
How to find the Multi Member File in As400 System?

Software/Hardware used:
AS400

Answer Wiki

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

Rajeshece,

Try DSPFD FILE(yourlib/yourfile) TYPE(*MBRLIST).

This will give you a list of members in the specified file.

Hope this helps,
Bill Poulin

Discuss This Question: 7  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
  • wpoulin
    Rajeshece, As I reread your question I wonder if I misunderstood. If you are trying to identify files that have multiple members, I would again use the DSPFD command, but to an outfile. Then run a query and select on the field ATNOMB (Number of members) greater than 1. Hope this helps, Bill Poulin
    2,480 pointsBadges:
    report
  • TomLiotta
    Also, do you want to:
    1. ...find out if a particular file has multiple members?
    2. ...find all files with multiple members?
    3. ...find files that are capable of having multiple members?
    The details of the question might be useful. Tom
    125,585 pointsBadges:
    report
  • rajeshece
    I wanted to find all the files which have multi members
    1,215 pointsBadges:
    report
  • wpoulin
    Rajeshece, Then my 2nd answer should work for you. Let us know if you need more detail. Thanks, Bill Poulin
    2,480 pointsBadges:
    report
  • TomLiotta
    Bill's answer is essentially correct. Example:
    DSPFD FILE( mylib/*ALL ) TYPE(*ATR) OUTPUT(*OUTFILE)
          FILEATR(*PF) OUTFILE( QTEMP/PFMBRCNT )
    That command would create an output file with one row for each physical file in library MYLIB. You could replace "mylib" with "*allusr" if you wanted to list every physical file in every user library. (That basically means "every non-IBM library".) You might then use SQL:
    SELECT PHLIB, PHFILE, PHNOMB FROM QTEMP/PFMBRCNT WHERE PHNOMB > 1
    That's probably the easiest way to list every physical file that has a member count greater than '1'. There are many variations. Tom
    125,585 pointsBadges:
    report
  • Rudedog
    you can do the DSPFD to an *OutFile (output file) and run query over it. then look for multiple members in a report format you design, sorted however you want it, as well as include/exclude records based on selection. -sarge
    950 pointsBadges:
    report
  • rajeshece
    [...] How to find the multi member file in AS/400 system? [...]
    0 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