Filter
Top Products
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 primary 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 required, and define the
type of membership of member records in a set, and
– specify the selection option for the set occurrences.
A maximum of 32 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 sets.
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 below.
SET NAME IS set-name
A name is assigned to the set.
[SET IS DYNAMIC]
The set is declared a dynamic set.
i