Displaying information about database files

 

Using iSeries™ Navigator and CL commands, you can display various types of information about database files.

• Displaying attributes of a file using iSeries Navigator
  You can use iSeries Navigator to display the attributes of a database file or a device file.

• Displaying attributes of a file using the Display File Description (DSPFD) command
  You can use the Display File Description (DSPFD) command to display the attributes of a database file. The information can be displayed, printed, or written to a database output file (OUTFILE).

• Displaying the description of the fields in a file
  You can use the Display File Field Description (DSPFFD) command to display field information for both database and device files. The information can be displayed, printed, or written to a database output file (OUTFILE).

• Displaying the relationships between files on the system
  You can use the Display Database Relations (DSPDBR) command to display the relationships between database files on the system. The information can be displayed, printed, or written to a database output file (OUTFILE).

• Displaying the files used by programs
  You can use the Display Program Reference (DSPPGMREF) command to determine which files, data areas, and other programs are used by a program. This information is available for compiled programs only and can be displayed, printed, or written to a database output file (OUTFILE).

• Displaying the system cross-reference files
  You can use the database files that are managed by the system to determine basic attribute and database file requirements. To display the fields in these files, use the Display File Field Description (DSPFFD) command.

 

Parent topic:

Using database attribute and cross-reference information