AS/400 File Maint.

280 pts.
Tags:
AS/400
DSPFD
I have a library that I would like to view all the files with the number of records and the number of deleted records on one report. DSPFD does this, but you must select each file one by one. This library has hundreds of files so that's not going to happen. Thank You, Douglas L McDuffie

Answer Wiki

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

The DSPFD has outfile capability. What this means is that you can select *ALL files in a particular library and dump all this to a file on the iSeries you can then query. The OUPUT parameter is set to *OUTFILE to do this and it will prompt you for a file name and library to dump data to. Don’t worry if the file does not exist because the file will be created. Make sure you are not overlaying a file that already exists though. On the command there is a parameter that allows you to select physical files only and the type of information parameter should be set to *MBRLIST which will give you record couts.

The iSeries info center has a CL finder command that you can display all information regarding all operting system commands. This is a sure fire go-to for quick information on a particular command. Here is a link to the V5R4 InfoCenter site.

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp

Hope this helps.

Discuss This Question: 2  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
  • Tpinky
    Hello, You can also do a DSPDBR that will give all the information. TPinky
    4,165 pointsBadges:
    report
  • Gilly400
    Hi, Afraid DSPDBR only gives you relations between files. It doesn't give details of number of records or deleted records. Regards, Martin Gilbert.
    23,730 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