Example
*** RECORD INFORMATION ***
DB-KEY-LOCATION AREA-WITHIN-LIST
REC REC CRR NR IMPL REC ITEM AREA-ID
REF RECORD-NAME DISPL DISPL KEYS SET DISPL DISPL DISPL LIST-OF-AREAS
2 CUSTOMER 0 0 0 0 60 3
3 CST-ORDERS 72 24 2 3
4 ORD-ITEM 88 48 1 3
5 INSTALMENT 96 72 1 28 3
6 ART-TYPE 128 96 1 29 1056 5 6 7 8 9
10
7 ART-SELECTION 160 120 1 30 1086 5 6 7 8 9
10
8 ART-DESCR 192 144 3 1116 5 6 7 8 9
10
9 ARTICLE 752 168 7 31 1146 5 6 7 8 9
10
10 SUBSET 840 192 0 1176 6 7
11 COLORS 848 216 2 32 11
12 MATERIALS 872 240 2 33 11
13 SUPPLIER 896 264 2 4
14 PURCHASE-ORDER 1032 288 0 4
15 P-ORD-ITEM 1048 312 0 4
Under the header RECORD INFORMATION, BPSIA prints out information on the record types of the subschema.
REC-REF
Number of the record type
RECORD-NAME
Name of the record type
REC DISPL
Displacement of the record type within the UWA relative to the beginning of the RECORD AREA
CRR DISPL
Displacement of the record type entry in the CURRENT-OF-RECORD table of the TCUA relative to the beginning of the table
NR KEYS
Number of keys defined for the record type; the keys defined on set level are included by BPSIA only if they are contained in a subschema set in which the record type is a member record type
IMPL SET
Number of the implicit set, if a SEARCH key has been defined on record type level
DB-KEY-LOCATION
Is printed by BPSIA only if a record defined with LOCATION MODE IS DIRECT or DIRECT-LONG occurs in the schema:
REC DISPL
Displacement of the area containing the database key, relative to the beginning of the RECORD AREA; if the database key item is contained in the record type, this area is the record area itself
ITEM DISPL
Displacement of the database key item relative to REC DISPL
AREA-WITHIN-LIST
Information on the realms in which records of the record type can be stored:
AREA-ID DISPL
Displacement of the AREA ID item in the WITHIN clause relative to the beginning of the RECORD AREA
LIST-OF-AREAS
Numbers of the realms in which – in accordance with the subschema description – records of the record type can be stored