News Stay informed about the latest enterprise technology news and product updates.

DSPFD (Display File Description)

The DSPFD (Display File Description) command is a favorite among iSeries (AS/400) users.

The DSPFD (Display File Description) command shows one or more types of information retrieved from the file descriptions of one or more database and/or device files. The information is provided for each file that has the specified name and that is found in the libraries named in the specified library qualifier to which the user has access. The information can be shown, printed or directed to a database output file (OUTFILE).

Here are a few tips for using the DSPFD command:

  • Maintaining the member name during transfers
    What do you do when you need to transfer many members of unique names from your iSeries to a PC using the .DTF file transfer technique and maintain the member name? expert Glen Bunnell has a technique that involves DSPFD.
  • Tracking shipping labels
    Using the DSPFD command, you can find the name of the original output queue defined in a particular printer file.
  • How to get information about your users' profiles
    Have you ever wanted to find out which users have not signed on in the past 90 days, or how many users are on the system? expert Ken Graap shows you how DSPFD and DSPFFD can be used to help you.
  • Simple object control
    Using DSPFD member Robert Davis has a technique that allows you to reorganize files and monitor potential problems with file sizes.
  • Use DSPFD to track file accesses and nip performance issues in the bud member Nick Hobson says it's easy to use journaling to gather information about the number of updates to a file, and it takes little or no preparation or overhead. The information is stored in each file object and can be extracted by simply using the DSPFD command.
  • Where's the source?
    You are a new programmer or consultant and you are assigned a seemingly simple change to an existing program. With your skills it will be a piece of cake. What is the first thing you do? You have to find the source. Not always easy. Member Jeff Worthington has a couple techniques using DSPPGM and DSPFD.
  • Recreate logicals without the source code
    Need to recreate logical files but you don't have the source code? Site expert Tim Granatir shows you how, using DSPFD.
  • Reorganize your files automatically
    Nico Beekhuijs uses DSPFD in his CL program for deleting and reorganizing files automatically.
  • Dynamically reorganizing DB2 files
    Here's one example of how information can be extracted from DB2 files and used to reorganize members only when deleted records exist.
  • Dynamically reorganizing DB2 files -- Take 2
    Site member Mary Milliron takes Peter Codispoti's tip and combines his three programs into one.
  • Getting member information into a database file expert Carol Woodbury shows you how you can get member information into a database file using DSPFD.

>> Return to list of commands.

Dig Deeper on iSeries programming commands