Using database attribute and cross-reference information

 

The i5/OS^® 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.

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

• Writing the output from a command directly to a database file
  You can store the output from many control language (CL) commands in an output physical file by specifying the OUTFILE parameter on the commands. You can then use the output files in programs or utilities (for example, Query) for data analysis.

 

Parent topic:

Managing database files

 

Related concepts

Control language

 

Related reference

Retrieve Member Description (RTVMBRD) command