Using database attribute and cross-reference information

The IBM i integrated database provides file attribute and cross-reference information.

Some of the cross-reference information include:
  • The files used in a program
  • The files that depend on other files for data or access paths
  • File attributes
  • The fields defined for a file
  • Constraints associated with a file
  • Key fields for a file

Each of the commands described in these topics can present information on a display, a printout, or write the cross-reference information to a database file that, in turn, can be used by a program or utility (for example, Query) for analysis.

You can retrieve information about a member of a database file for use in your applications with the Retrieve Member Description (RTVMBRD) command.