HP System Dictionary/XL General Reference Manual Vol 1 (32256-90004)

7- 103
the IMAGE-DATASET contains HPDBE-FILE relationship type.
Example
To define the data set CUSTOMER, create the data set CUSTOMER with image-dataset-type equal to
MANUAL.
Create the RECORD CUSTOMER-REC to define the record layout of data set CUSTOMER.
Create each of the ELEMENTs ACCOUNT, NAME and CITY.
Relate each of these ELEMENTs to RECORD CUSTOMER-REC using the RECORD contains ELEMENT
relationship type. The byte-offset for ACCOUNT is 1, for NAME is 5, for CITY is 95.
Relate CUSTOMER-REC to CUSTOMER using the IMAGE-DATASET contains RECORD relationship
type.
Search Item
The search item of a master or relation data set is defined by the IMAGE-DATASET key ELEMENT
relationship type. That is, the ELEMENT (search item) is related to the MANUAL or RELATION data set
for which it is a key. Note that the primary record layout for this data set should contain this ELEMENT.
Also note that there is no need to establish a key for an AUTOMATIC data set since the primary record
layout should contain only the search item.
Example
To define the search item for data set CUSTOMER, relate the ELEMENT ACCOUNT to the data set
CUSTOMER with the IMAGE-DATASET key ELEMENT relationship type.
Chain
Every chain within a detail data set is fully defined by:
1 The child (detail or relation) data set the chain is in
2 The search item
3 The sort item, if any
4 The path to a parent (master or relation) data set
5 The database the chain is in
This is considered a five-way relationship. To define this five-way relationship in the dictionary, use the
five-way relationship type:
image-dataset
element
element
image-dataset
image-database
where the relationship class is chains. Note that the order of these entity types is very important.
Information regarding the order of entity types in a relationship type is located in Chapter 3 of this
manual.