TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

86 Chapter3
Defining a Database
Schema Processor Output
Schema Processor Output
The Schema Processor prints the following heading on the first page of the listing:
PAGE 1 HEWLETT-PACKARD 30391C.05.00 TurboIMAGE/3000: DBSCHEMA
MON, JAN 10, 1994, 3:32 PM (C) HEWLETT-PACKARD CO. 1987
If your standard output device ($STDLIST) is different from the list file, an abbreviated
product identification is also printed on $STDLIST. Subsequent pages of the list file are
headed by a page number, the database name if it has been encountered, and the title most
recently specified by a $TITLE or $PAGE command.
If the LIST option is active, a copy of each record of the schema is sent to the list file.
However, if the text file and list file are the same, as for example they are when you enter
the schema source from your terminal in session mode, the records are not listed. If you
are entering the schema in this way, the Schema Processor prompts for each line of input
with a right angle bracket (>).
Summary Information
After the entire schema has been scanned, several types of summary information can be
printed on the list file.
• If some of the items defined in the item part are not referenced in the set part, and if no
errors are encountered, the message UNREFERENCED ITEMS:list of items is printed to
the list file. The list includes all items defined but not referenced in a data set. Although
they are not considered errors, these extraneous items should be removed to reduce the
size of the tables in the root file and the size of the control blocks used by the library
procedures.
• If no errors are detected in the schema, the Schema Processor prints a table of
summary information about the data sets. Figure 3-4. contains a sample printout of this
information. Figure 3-4. describes the information contained in the summary. The
NOTABLE parameter of the $CONTROL command suppresses printing of this table.
Figure 3-4. Data Set Summary Table
DATA SET TYPE FLD PT ENTR MED MAXIMUM BLK BLK DISC
NAME CNT CT LGTH REC CAPACITY FAC LGTH SPACE
EMPLOYEE Mi 4 1 7 17 500 30 512 72
PROJECT-MASTER M 2 1 10 20 75 19 382 15
LABOR D 4 2 10 18 20048 28 506 1436
INITIAL CAPACITY: 10024 INCREMENT ENTRIES: 2016
TOTAL DISC SECTORS INCLUDING ROOT: 1532