09/23/08 How to always see correct field names for a physical file

To quickly see the fields that are available in a physical file without having to run a SQL statement use the DSPFFD command.

  1. Type from command line DSPFFD
  2. Press F4
  3. Type the File name and the Library where it is located
  4. Press Enter
You will see the all the column names in the file along with their descriptions.

This simple command is often superior to running a SQL statement because the names of fields in a file are not always correctly shown when using SQL. The DSPFFD command will always return the correct naming convention of the column names.

Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.

No comments: