Types of access Schema DDL
104 U929-J-Z125-9-76
Simultaneous automatic selection of several owner records from one record type
With certain data structures, it m ay be necessary to select several set occurrences (i.e.
several owner records) at the same time when inserting a new member record, wher e all
owner records are part of the same record type.
Such a case applies when the following two conditions are met:
– Two record types are connected by more than one set.
– The member record type is defined as an AUTOMATIC member in at least two of these
sets.
If the selection option LOCATION MODE OF OWNER has been defined, UDS/SQL
automatically selects the set occurrences of the sets. In order to s elect several different
owner records simultaneously, however, the user then requires an additional language
resource, because it is not possible to provide the items defined as pr imary keys with
LOCATION MODE IS... with multiple key values at the same time.
The following clause can be used to create an additional item for the owner selection in this
set to hold the key values:
⎧item-name ⎫
ALIAS FOR ⎨ ⎬ IS identifier-2
⎩identifier-1⎭
item-name and identifier-1 specify items that have been declared primary keys by LOCATION
MODE IS... .
identifier-2 specifies the name of the additional item to be created. UDS/SQL automati cally
provides this item with the same item type and length as items referred to by item-name or
identifier-1.
If a key consisting of several items has been defined by LOCATION MODE IS CALC, the
ALIAS clause must be repeated an appropriate number of tim es in order to create one
substitute item for every key item.