Filter
Top Products
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\uds\Manuale\en\udsent_e\udsent.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 occurrence 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 left 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; pointer 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 page 100).
Water
ARTICLE
Cocoa
Lemonade
ARTICLES-
AVAILABLE
SUPPLIER
Moore
Beer