Fujitsu UDS/SQL V2.5 - page 101

Schema DDL Types of access
U929-J-Z125-9-76 101
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
Example
RECORD NAME IS SUPPLIER
.
.
.
RECORD NAME IS ARTICLE
.
.
.
01 ARTICLE-NAME PICTURE IS X(30).
SET NAME IS ARTICLES-AVAILABLE
ORDER IS SORTED INDEXED BY DEFINED KEYS.....
OWNER IS SUPPLIER
MEMBER IS ARTICLE.....
ASCENDING KEY IS ARTICLE-NAME
.
.
.
ORDER IS SORTED INDEXED BY DATABASE-KEY
Specifies the order of the members of a set occurrence (see the section “Determining the
order of records within a set occurrence” on page 98). It also sets up a multi-level table for
each set occurrence of the set. The table represents a unique reference between database
key value and physical address for each record belonging to the set occurrence. UDS/SQL
makes use of this access path when inser ting a record in or deleting a record from the set
occurrence and in sequential reading, but not for direct accesses.