Schema DDL Reference section
244 U929-J-Z125-9-76
This clause is used to assign a name to a set and to
– declare the set a dynamic set if required,
– define the sequence of the member records within the set occurrences for sequential
processing,
– define additional access paths via primar y and secondary keys,
– declare a record type to be the owner record type of the set,
– declare a record type to be a member record type of the set if r equired, and define the
type of membership of member records in a set, and
– specify the selection option for the set occurrences.
A maximum of 3 2 766 sets can be defined per database.
For each record type which is owner of a set you can generate a maximum of 255
tables in these sets. A table is created when the set mode pointer array or list or
chain is of the type sorted indexed, also for each secondary key in these s ets.
Irrespective of this you may define up to 255 secondary keys per record type on
record type level and per singular set on set level; hash routines are not counted
here.
The individual clauses of the set entry are explained be low.
SET NAME IS set-name
A name is assigned to the set.
[SET IS DYNAMIC]
The set is declared a dynamic set.
i