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 combin ation of items of the member record type
as sort key. The member records within the set occurrence are sorted in ascendi ng 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 ty pe.
name specifies the name of the table; referred to in the SSL statements.
This clause is used to define additional direct ac cess 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.