Schema DDL Types of access
U929-J-Z125-9-76 99
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
Figure 25: Sorting a set occurrence according to the key ART-NAME
ORDER IS SORTED BY DATABASE-KEY
UDS/SQL sorts the member records of the set occurr ence in ascending order according to
the values of the database key. In this case, the database key is also referred to as primary
key of the set.
The values of the database key can be defined by the user (see the section “Direct and
sequential access on record type level via database key value” on page 85) or le ft to
UDS/SQL.
If, by means of SSL, a storage mode is established which causes UDS/SQL to set up a table
in order to sort a set occurrence (see page 144; p ointer array, list), UDS/SQL also uses the
table as direct access path.
In this case, the above clause must be supplemented by INDEXED, which results in the
creation of a multi-level table (see page1 00).
Water
ARTICLE
Cocoa
Lemonade
ARTICLES-
AVAILABLE
SUPPLIER Moore
Beer