Schema DDL SEARCH KEY and ORDER clause
U929-J-Z125-9-76 107
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007 24. Oktober 2007 Stand 09:30.23 Pfad: G:\vogt\fsc\ud s\Manuale\en\udsent_e\uds ent.k04
4.9 Assigning names to hash areas and tables Names must be assigned to hash areas and tables for secondary keys and tables for
primary keys if they are to be referenced by the SSL for the following purposes:
– determining the physical placement of the hash areas and tables
– preventing redundancy in tables
– defining the type of table reorganization desired
Names are assigned to hash areas or tables for secondary keys on record type and on set
level by:
⎧CALC ⎫
SEARCH KEY IS..... USING ⎨ ⎬ NAME IS name.....
⎩INDEX⎭
Names are assigned to tables for primary keys on set level by means of:
ORDER IS SORTED INDEXED NAME IS name.....
where name specifies the name of the hash area or the table.