Example
*** KEY INFORMATION (NO CALC-SEARCH KEYS) *** SET KEY DUPL DUPL LIST PPP-BITS DBTT SSIA OWNER TABLE-ACTKEY REF SET-NAME REF TYPE LNGTH NOT TABLE TABLE INDEX ATT SET O M TAB SPLIT COLUM DISPL DISPL AREA BNR 1 CST-ORD-PLACED 1 ASC 4 * * * * 2 1 0 0 2 SEARCH 6 * * 2 2 28 0 2 CST-O-CONTENTS 3 ASC 2 * * * 2 1 0 0 3 OUTSTANDING * 2 0 0 4 HIRE-PURCHASE * 2 0 0 5 OFFER 4 ASC 40 * * 5 1 0 0 11 6 SHORT-LIST 5 ASC 40 * * 5 1 0 11 7 P-ORD-SPEC 6 ASC 4 * * * * 2 1 0 0 0 8 MIN-STOCK-LEVEL 7 ASC 10 * * * 2 1 0 5 8 9 CONTAINING * 2 0 0 10 CONTAINED-IN * 2 0 0 11 SUPPLIERS 8 ASC 35 * * * 2 1 0 4 22 12 ARTICLES-AVAILABLE 9 ASC 40 * * 5 1 0 0 10 SEARCH 1 * * * 2 2 28 0 13 ORDERED-ARTICLES * 2 0 0 14 REORDERED-ARTICLES * 2 0 0 15 P-ORD-PLACED * 2 0 0 16 P-ORD-RECEIVED * 2 0 0 17 P-ORD-CONTENTS * * * 2 1 0 0 4 18 RESULT-SET ASC 1 * * * 2 1 0 12 0 19 LIMITED-SET ASC 1 * * * 2 1 0 12 0 20 IQL-DYN1 ASC 1 * * * 2 1 0 12 0 21 IQL-DYN2 ASC 1 * * * 2 1 0 12 0 22 IQL-DYN3 ASC 1 * * * 2 1 0 12 0 23 IQL-DYN4 ASC 1 * * * 2 1 0 12 0 24 IQL-DYN5 ASC 1 * * * 2 1 0 12 0 25 IQL-DYN6 ASC 1 * * * 2 1 0 12 0 26 IQL-DYN7 ASC 1 * * * 2 1 0 12 0 27 IQL-DYN8 ASC 1 * * * 2 1 0 12 0 28 SYS_INSTALMENT 11 SEARCH 6 * * * 2 1 0 3 11 30 SYS_ART-SELECTION 13 SEARCH 25 * * 5 1 0 11 31 33 SYS_MATERIALS 18 SEARCH 1 * * * 5 1 0 11 34 19 SEARCH 20 * * * 5 2 28 11 35 34 IMPLICIT_RESULT_SET ASC 1 * * * 0 1 0 12 0
The items printed in bold contain the value '0' before the BFORMAT utility routine is run.
Under the header KEY INFORMATION (NO CALC-SEARCH KEYS), BPSIA prints out information about the keys defined on the record type level and set level in the schema. The table does not contain any information on CALC keys and CALC SEARCH keys (see chapters "CALC INFORMATION" and "CALC-SEARCH-KEY INFORMATION").
SET REF
Number of the set to which the key belongs
SET-NAME
Name of the set
KEY REF
Number of the key
TYPE
Type of key
ASC:
ASCENDING key
DESC:
DESCENDING key
SEARCH:
SEARCH key (USING INDEX)
DBKEY:
sorted by record sequence number
LNGTH
Overall length of the key item
DUPL NO
Marker indicating whether duplicate key values are allowed or not
*: Duplicates are not allowed
DUPL TABLE
Marker for duplicates tables
*:
Duplicates tables set up (TYPE IS DATABASE-KEY-LIST)
'BLANK':
No duplicates tables set up (TYPE IS REPEATED-KEY)
TABLE
Marker for table
*: Table set up
INDEX
Marker indicating whether a single-level or multi-level table has been set up
*: Multi-level table
ATT
Marker indicating whether a set occurrence is to be stored in close proximity to the owner
*: ATTACHED TO OWNER
LIST SET
Marker indicating whether the set occurrence table has been set up as a list
*: List
PPP-BITS
* means the following with
O
Owing to relocation of owner records, e.g. with BREORG, probable position pointers (PPPs) which refer to these owner records are very probably no longer up to date
M
Owing to relocation of member records, e.g. with BREORG, probable position pointers which refer to these member records are very probably no longer up to date
TAB
Owing to relocation of tables, e.g. with BREORG, probable position pointers which refer to these tables are very probably no longer up to date
Probable position pointers can also exist without these displays being set because the DBH does not maintain these bits when individual records are relocated. The displays are as a rule set when all records have been relocated by utility routines.
It may be useful to perform a BREORG run.
SPLIT
Number of pages specified in the REORGANIZATION clause
2: Default value; also applies when no table exists
DBTT COLUM
Column number in the DBTT of the owner record type in which the address of the table has been entered
0: No table
SSIA DISPL
Displacement of key description in the SSIA relative to the beginning of all key information for this set
OWNER DISPL
Within the set connection data for this set in the owner record type:
displacement of the item containing the address of the table; only applicable if the table has been defined with WITH PHYSICAL LINK option
TABLE-ACTKEY
For standard sets:
AREA:
Number of the realm in which the table is stored (DETACHED WITHIN);
0: Table is stored in the realm of the owner record type (DETACHED or ATTACHED)
BNR:
No entry for standard sets
In the case of non-standard sets: address of the table
Realm number
BNR:
Page number; 0 for dynamic sets