Example
*** SET INFORMATION ***
SOS-OWNER-INFO (DIR) (CALC) SET NR CRS CRS-SORT LOC REC ITEM NR ITEM DB-REC ITEM ITEM REF SET-NAME KEYS DISPL KEY-DISPL OWN ALIAS DISPL DISPL ITEMS REF DISPL LENGTH TYPE SET-READY-LIST 1 CST-ORD-PLACED 2 0 0 DIR 0 60 3 2 CST-O-CONTENTS 1 80 4 3 3 OUTSTANDING 0 160 0 DIR 0 60 3 4 HIRE-PURCHASE 0 240 0 DIR 0 60 3 5 OFFER 1 320 6 5 6 7 8 10 11 6 SHORT-LIST 1 400 46 5 6 7 8 10 11 7 P-ORD-SPEC 1 480 86 5 6 7 8 10 11 8 MIN-STOCK-LEVEL 1 560 90 5 6 7 8 10 11 9 CONTAINING 0 640 0 CALC 752 3 0 128 6 5 5 6 7 8 6 134 2 5 10 11 54 182 2 5 10 CONTAINED-IN 0 720 0 CALC * 1056 3 150 128 6 5 5 6 7 8 156 134 2 5 10 11 158 182 2 5 11 SUPPLIERS 1 800 100 4 12 ARTICLES-AVAILABLE 2 880 135 4 5 6 7 9 10 11 13 ORDERED-ARTICLES 0 960 0 CALC 752 3 0 128 6 5 3 5 6 7 6 134 2 5 9 10 11 54 182 2 5 14 REORDERED-ARTICLES 0 1040 0 CALC 752 3 0 128 6 5 4 5 6 7 6 134 2 5 9 10 11 54 182 2 5 15 P-ORD-PLACED 0 1120 0 4 16 P-ORD-RECEIVED 0 1200 0 4 17 P-ORD-CONTENTS 0 1280 0 4 ... 28 SYS_INSTALMENT 1 0 0 3 29 SYS_ART-TYPE 1 0 0 5 6 7 8 10 11 30 SYS_ART-SELECTION 1 0 0 5 6 7 8 10 11 31 SYS_ARTICLE 2 0 0 5 6 7 8 10 11 32 SYS_COLORS 2 0 0 11 33 SYS_MATERIALS 2 0 0 11 34 IMPLICIT_RESULT_SET 0 2160 0
Under the header SET INFORMATION, BPSIA prints out a table with information about all sets of the subschema.
SET-REF
Set number
SET-NAME
Name of the set
NR KEYS
Number of keys of the set’s member record
CRS DISPL
Displacement of the set entry in the CURRENT OF SET table of the TCUA relative to the beginning of the table
CRS-SORT KEY-DISPL
Displacement of the ASC key entry or DESC key entry relative to the beginning of the KEY AREA in the TCUA
SOS-OWNER-INFO
Information on the owner of the set, if the SET OCCURRENCE SELECTION clause has been specified with THRU LOCATION MODE OF OWNER in the DDL:
LOC OWN:
LOCATION MODE of the owner record type
CALC:
With hash routine
DIR:
DIRECT or DIRECT-LONG, i.e. with database key
ALIAS
*: ALIAS clause defined
REC DISPL
Displacement of the record type relative to the beginning of the RECORD AREA in which the item for locating the owner is situated.
If identifier or the ALIAS clause has been specified, this is an implicit record containing all implicitly defined items.
(DIR)
Only if the LOCATION MODE of the owner is DIRECT or DIRECT-LONG:
ITEM DISPL
Displacement of the database key item, relative to REC DISPL
(CALC)
Only if the LOCATION MODE of the owner is CALC:
NR ITEMS
Number of items making up the CALC key
ITEM REF
Displacement of the CALC key item within the subschema record.
If an ALIAS clause has been specified: displacement of the ALIAS item within the record for implicitly defined items
DB-REC-DISPL
Displacement of the CALC key item in the schema record including set connection data
ITEM LENGTH
Length of the CALC key item or of the ALIAS item including set connection data
ITEM TYPE
Type of the CALC key item or ALIAS item (see "CALC KEY INFORMATION")
SET READY LIST
Numbers of the realms which can be referenced when accessing via set