CL Command Reference - ANZDBFKEY

CL Command List > ANZDBFKEY Reference

Description:

The Analyze Database File Keys (ANZDBFKEY) command produces, from the data generated by the Analyze Database File (ANZDBF) command, two reports showing the key structure of the database files.

One report is written to the printer file QPPTANZK. The other report is written to the printer file QPPTANKM. QPPTANZK contains a listing of the access paths and (logical files only) selection criteria for each key field or selection rule. QPPTANKM contains a matrix of the key fields for all logical files based on the physical file.


Examples:

ANZDBFKEY FILE(*NUMLF) NUMLF(2)

This command produces reports on the keys for all files that refer to physical files with at least two associated logical files.