Home > IT Answers > AS/400 > How to see records in ALL Files to an OutFile
Alison883
75 pts.
0
Q:
How to see records in ALL Files to an OutFile
AS/400 Query, AS/400 output files
I have a programmer that wants to see all Files in a specific library that have 0 records. I know I can do a dspfd on all files in a specific library but I can't display it to an outfile. I wanted to run a query over the outfile. Can someone offer any suggestions on which command or program I could use? Thanks so much !
ASKED: Apr 6 2009  4:41 PM GMT
0
Philpl1jb
24105 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Yes, you can send DSPFD to an outfile.
Use *MBRLIST for the type
and you'll want to limit it to FILEATR *PF

Then you'll have fields like
Current number of records MLNRCD
Number of deleted records MLNDTR

At least you can in V6R1
Phil
Last Answered: Apr 6 2009  5:40 PM GMT by Philpl1jb   24105 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Alison883   75 pts.  |   Apr 6 2009  7:19PM GMT

Phil Thanks so much for the correct command, it worked perfectly. I knew there had to be a way but I just couldn’t get it right.

 
0