Display Record Format tool

320 pts.
Tags:
AS/400
In another shop, we had a tool called "DRF" it was a command that when prompted, would require a file name and library be entered. It would then display the files fields, from and to lengths as well as field descriptions and keys and other information in a very compact, neat report. I was told that it was a tool that could be downloaded from the web but now that I'm in a new shop, I am unable to loacte anything that is even close to the DRF tool. Does anyone know of this tool and where it can be found?
ASKED: November 18, 2005  9:58 AM
UPDATED: November 25, 2005  12:23 PM

Answer Wiki

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

don’t search too far,

for a field list, just do
DSPFFD FILE(&lib/&file) OUTPUT(*OUTFILE)
OUTFILE(JPL/FFD)
then show the outputed file (with a green screen, a query, a sql, a web page or whatever you want)
(output file will be a copy of QADSPFFD, build your rpg based on file QADSPFFD)

for a key list,
DSPDBR FILE(&PFLIB/&PF) OUTPUT(*OUTFILE)
OUTFILE(QTEMP/DSPDBR)
then loop on the file to
DSPFD FILE(&WHRELI/&WHREFI) TYPE(*ACCPTH) +
OUTPUT(*OUTFILE) FILEATR(*LF) +
OUTFILE(QTEMP/DSPFD) OUTMBR(*FIRST *ADD)
then show QTEMP/DSPFD.
(template file is QAFDACCP)

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
  • astradyne
    DRF was a Java tool written by Alex Garrison and used to be available for download from the AS400 NetJava Expert site. The site is no longer available and the only reference I can find on the net for DRF is a posting from back in 1999. It might be worth trying to contact the author via the MC Press Online site to see if he is able to help and willing to repost it. Alternatively Linoma Software do a single user free licence (or used to) for their Surveyor/400 product. This is a GUI file utility that runs on the PC and may suit your needs. All the best Jonathan
    370 pointsBadges:
    report
  • Floyd02
    Thank you.
    320 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