Data Definition Language (DDL) Reference Manual

Introduction to DDL

Data Definition Language (DDL) Reference Manual—529431-004

1-14

Examining a Dictionary

The DDL compiler produces a schema listing by default. In addition, the DDL compiler

can produce a schema report that provides information about the object definitions in a

schema. For each 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 Plus

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 the DDL compiler

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 Plus

reports supplied by HP as templates, changing them or adding to them to suit your

needs.

Figure 1-6 on page 1-15 shows how to produce a DDL schema report and how to

produce dictionary reports using Enform Plus:

1. Produce schema report

Run the DDL compiler with the schema as the input file and include the REPORT

command in the RUN DDL command. Or, run the DDL compiler interactively,

compile a DDL schema file, and request the report with a REPORT command. The

dictionary need not be open. By default, the DDL compiler 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 the

DDL compiler interactively with the REPORT command specified in the RUN DDL

command and request reports using the OUTPUT statement.

2. Produce dictionary reports

The dictionary must exist, but it need not be open. Run Enform Plus 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 Plus 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.