1,025 pts.
 How to find the Multi Member File in As400 System?
How to find the Multi Member File in As400 System?

Software/Hardware used:
AS400
ASKED: June 25, 2010  8:53 AM
UPDATED: April 17, 2011  2:46 PM

Answer Wiki:
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
Last Wiki Answer Submitted:  April 17, 2011  2:46 pm  by  ITKE   0 pts.
All Answer Wiki Contributors:  ITKE   0 pts. , wpoulin   2,480 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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 pts.

 

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

 108,135 pts.

 

I wanted to find all the files which have multi members

 1,025 pts.

 

Rajeshece,
Then my 2nd answer should work for you.
Let us know if you need more detail.
Thanks,
Bill Poulin

 2,480 pts.

 

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

 108,135 pts.

 

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 pts.