Under the header SET INFORMATION, BPSIA prints out two tables containing information on the sets defined in the schema.
Example
*** SET INFORMATION *** REF SET-NAME TYPE MODE ORDER INSERT REMOVE SOS INIT INCR T-AREA P-AREA 1 CST-ORD-PLACED PTRAY SORT AUTO TRAN OWN 10 1 2 CST-O-CONTENTS PTRAY SORT AUTO PERM CUR 0 1 3 OUTSTANDING CHAIN LAST AUTO TRAN OWN 0 1 4 HIRE-PURCHASE CHAIN LAST AUTO PERM OWN 0 1 5 OFFER PTRAY SORT AUTO PERM CUR 100 5 6 SHORT-LIST PTRAY SORT AUTO PERM CUR 100 20 7 P-ORD-SPEC LIST SORT AUTO PERM CUR 15 1 8 MIN-STOCK-LEVEL SING CH-PR SORT MANL TRAN 0 1 9 CONTAINING CHAIN NEXT AUTO PERM OWN 10 1 10 CONTAINED-IN CH-PR NEXT AUTO PERM OWN 0 1 11 SUPPLIERS SING PTRAY SORT AUTO PERM 0 1 12 ARTICLES-AVAILABLE PTRAY SORT AUTO PERM CUR 500 1 13 ORDERED-ARTICLES CHAIN LAST AUTO PERM OWN 0 1 14 REORDERED-ARTICLES CHAIN LAST AUTO PERM OWN 0 1 15 P-ORD-PLACED CHAIN LAST AUTO PERM CUR 0 1 16 P-ORD-RECEIVED CHAIN FIRST MANL PERM CUR 0 1 17 P-ORD-CONTENTS LIST NEXT AUTO PERM CUR 20 1 18 RESULT-SET DYN PTRAY SORT MANL TRAN 0 1 19 LIMITED-SET DYN PTRAY SORT MANL TRAN 0 1 20 IQL-DYN1 DYN PTRAY SORT MANL TRAN 0 1 21 IQL-DYN2 DYN PTRAY SORT MANL TRAN 0 1 22 IQL-DYN3 DYN PTRAY SORT MANL TRAN 0 1 23 IQL-DYN4 DYN PTRAY SORT MANL TRAN 0 1 24 IQL-DYN5 DYN PTRAY SORT MANL TRAN 0 1 25 IQL-DYN6 DYN PTRAY SORT MANL TRAN 0 1 26 IQL-DYN7 DYN PTRAY SORT MANL TRAN 0 1 27 IQL-DYN8 DYN PTRAY SORT MANL TRAN 0 1 28 SYS_INSTALMENT IMPL SORT AUTO PERM 0 1 29 SYS_ART-TYPE IMPL SORT AUTO PERM 0 1 30 SYS_ART-SELECTION IMPL SORT AUTO PERM 0 1 31 SYS_ARTICLE IMPL SORT AUTO PERM 0 1 32 SYS_COLORS IMPL SORT AUTO PERM 0 1 33 SYS_MATERIALS IMPL SORT AUTO PERM 0 1 34 IMPLICIT_RESULT_SET DYN PTRAY SORT MANL TRAN 0 1
The first table contains the following entries:
REF
Set number
SET NAME
Set name
TYPE
Set type
DYN:
Dynamic set
IMPL:
Implicit set
SING:
SYSTEM set (singular set)
'BLANK''BLANK''BLANK''BLANK':
Standard set
MODE
Set mode
CHAIN:
Chain
CH-PR:
Chain with backward chaining (CHAIN LINKED TO PRIOR)
LIST:
List
PTRAY:
Pointer array
'BLANK''BLANK''BLANK''BLANK':
Implicit set
ORDER
Sort sequence within the set occurrences of the set
INSERT
Insertion of new member records in the set
AUTO:
AUTOMATIC
MANL:
MANUAL
REMOVE
Type of set membership
PERM:
Permanent (MANDATORY member)
TRAN:
Transient (OPTIONAL member)
SOS
Set occurrence selection (in the case of non-singular sets only)
CUR:
THRU CURRENT OF SET
OWN:
THRU LOCATION MODE OF OWNER
INIT
Initial number of set occurrences according to the POPULATION clause for this set
INCR
Number of entries by which a set occurrence can be increased according to the INCREASE clause for this set
T-AREA
Realm number of the table part (pages with levels >0) of a distributable list which is distributed over more than one realm (“table realm”).
P-AREA
Realm number of the realm in which the DBH is currently searching for free pages to store member records of a distributable list which is distributed over more than one realm (“preferred realm”).
SET PHYS OWNER SCD-DISPL SCD-LNGTH CHAIN-LNK REF SET_NAME OWNER MEMBER LNK RSQ OWN MEM OWN MEM OWN MEM ANCHOR-ACT ANCHOR-DBK 1 CST-ORD-PLACED 2 3 0 0 0 0 6 3 2 CST-O-CONTENTS 3 4 0 0 0 0 6 3 3 OUTSTANDING 2 4 12 0 6 24 18 4 13 4 HIRE-PURCHASE 2 5 12 24 0 24 18 5 OFFER 6 8 0 0 4 4 6 6 6 SHORT-LIST 7 8 0 0 10 0 6 7 P-ORD-SPEC 8 9 * 0 0 84 4 10 8 8 MIN-STOCK-LEVEL 0 9 0 8 94 24 24 11 12 5 9 0 1 9 CONTAINING 9 10 * 12 0 0 12 22 10 10 10 CONTAINED-IN 9 10 * 24 12 22 24 34 13 11 SUPPLIERS 0 13 0 0 36 0 1 28 4 23 0 2 12 ARTICLES-AVAILABLE 13 9 * 0 0 118 0 10 15 13 ORDERED-ARTICLES 9 4 * 12 36 24 24 22 14 14 REORDERED-ARTICLES 9 15 * 12 60 0 24 22 17 15 P-ORD-PLACED 13 14 12 0 4 24 18 16 16 16 P-ORD-RECEIVED 13 14 12 24 22 12 18 17 P-ORD-CONTENTS 14 15 0 0 22 4 6 18 RESULT-SET 0 0 0 0 0 0 0 19 12 8 0 0 19 LIMITED-SET 0 0 0 0 0 0 0 20 12 8 0 0 20 IQL-DYN1 0 0 0 0 0 0 0 21 12 8 0 0 21 IQL-DYN2 0 0 0 0 0 0 0 22 12 8 0 0 22 IQL-DYN3 0 0 0 0 0 0 0 23 12 8 0 0 23 IQL-DYN4 0 0 0 0 0 0 0 24 12 8 0 0 24 IQL-DYN5 0 0 0 0 0 0 0 25 12 8 0 0 25 IQL-DYN6 0 0 0 0 0 0 0 26 12 8 0 0 26 IQL-DYN7 0 0 0 0 0 0 0 27 12 8 0 0 27 IQL-DYN8 0 0 0 0 0 0 0 12 8 0 0 28 SYS_INSTALMENT 0 5 0 0 0 0 0 29 4 3 12 0 3 29 SYS_ART-TYPE 0 6 0 0 0 0 0 30 5 10 0 4 30 SYS_ART-SELECTION 0 7 0 0 0 0 0 31 11 32 0 5 31 SYS_ARTICLE 0 9 0 0 0 0 0 32 7 5 11 0 6 32 SYS_COLORS 0 11 0 0 0 0 0 33 11 33 0 7 33 SYS_MATERIALS 0 12 0 0 0 0 0 11 36 0 8 34 IMPLICIT_RESULT_SET 0 0 0 0 0 0 0 0 0 0 0
The second table contains the following entries:
SET REF
Set number
SET-NAME
Set name
OWNER
Number of the owner record type in the case of a non-singular set
0: indicates a singular set
MEMBER
Number of the member record type
0: indicates a dynamic set
PHYS LNK
Marker for additional link between member records and their owner record (physical linked to owner)
*: Additional link defined
OWNER RSQ
Within the set connection data of the member record type: displacement of the item with the record sequence number of the owner record relative to the beginning of the set connection data (see the “Design and Definition” manual).
SCD-DISPL
Displacement of the set connection data relative to the beginning of the record:
OWN
in the owner record type
MEM
in the member record type
SCD-LNGTH
Length of the set connection data of the set:
OWN
in the owner record type
MEM
in the member record type
CHAIN-LNK
Number of the next set with:
OWN
the same owner record typ
MEM
the same member record type
ANCHOR-ACT
Address (realm number and page number) of the anchor record of a SYSTEM set. For dynamic sets, the realm number points to the temporary realm, since dynamic sets are stored in temporary realms.
ANCHOR-DBK
Database key of the anchor record of ANCHOR-ACT
(number of the record type = 0)