Introduction to DDL
Data Definition Language (DDL) Reference Manual — 426798-002
1- 12
Examining a Dictionary
object, this report lists its type and size, its byte offset from the start of a group
definition, and any definitions referenced by other objects.
You can also generate reports on the dictionary itself. HP supplies a set of Enform
queries that provide information about any dictionary. These reports are particularly
useful for anyone acting as the administrator of a database. The reports:
•
Show all the components of a dictionary.
•
Tell when structures were last modified, which version of DDL produced the
dictionary, which definitions are used by which other definitions, and where they
are used.
•
List file definitions and the key fields used by files.
•
List all display text and comments stored in the dictionary.
If you want to produce your own dictionary reports, you can use the Enform reports
supplied by HP as templates, changing them or adding to them to suit your needs.
Figure 1-6
on page 1-13 shows how to produce a DDL schema report and how to
produce dictionary reports using Enform:
1. Produce schema report
Run DDL with the source schema as the input file and include the REPORT
command in the DDL run command. Or, run DDL interactively, compile a DDL
source schema file, and request the report with a REPORT command. The
dictionary need not be open. By default, DDL sends the report to its home terminal;
alternatively, you can specify a printer as the report destination. If you need
information only on selected definitions in the dictionary, you can run DDL
interactively with the REPORT command specified in the DDL run command and
request reports using the OUTPUT statement.
2. Produce dictionary reports
The dictionary must exist, but it need not be open. Run Enform from the volume
and subvolume on which the dictionary resides using the file
$SYSTEM.SYSTEM.DDQUERYS as the input file. To select particular reports, you
can run Enform interactively and specify sections (R1 to R12) of the query file.
Each section corresponds to a report.
For more information on producing dictionary reports, see
Appendix E, Dictionary
Reports
.