iX V6.5 (30391-90011)

86 Chapter3

Deﬁning a Database

Schema Processor Output

The Schema Processor prints the following heading on the ﬁrst 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 ﬁle, an abbreviated

product identiﬁcation is also printed on $STDLIST. Subsequent pages of the list ﬁle are

headed by a page number, the database name if it has been encountered, and the title most

recently speciﬁed 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 ﬁle.

However, if the text ﬁle and list ﬁle 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 ﬁle.

• If some of the items deﬁned 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 ﬁle. The list includes all items deﬁned 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 ﬁle 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