Filter
Top Products
Schema DDL Reference section
246 U929-J-Z125-9-76
⎧ASCENDING ⎫
[⎨ ⎬ KEY IS item-name,...]
⎩DESCENDING⎭
item-name,...
denotes an item of fixed length that belongs to the record type.
This clause is used to define an item or a combination of items of the member record type
as sort key. The member records within the set occurrence are sorted in ascending or
descending order, according to the values of this key.
⎧CALC[ hash-routine]⎫
[SEARCH KEY IS item-name,... USING ⎨ ⎬[ NAME IS name]
⎩INDEX ⎭
DUPLICATES ARE[ NOT] ALLOWED]...
item-name,...
must specify an item of fixed length that belongs to this record type.
name specifies the name of the table; referred to in the SSL statements.
This clause is used to define additional direct access paths via secondary keys and to
assign a name to the SEARCH key table or the hash area, which can be referenced in the
SSL.
SEARCH KEY ... USING CALC is permitted only with a SYSTEM set.