Structure of records and tables Table structure
U929-J-Z125-9-76 227
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007 24. Oktober 2007 Stand 12:03.14 Pfad: G:\vogt\fsc\ud s\Manuale\en\udsent_e\uds ent.k08
The table lines of a higher table level contain act-keys pointing to the associated pages of
the next lower table level.
The table lines of the lowest table level contain PPPs which indicate the pages where the
associated records are stored. If a PPP is not cu rrent, UDS/SQL finds the record by means
of the RSQ via the DBTT.
The hierarchic structure of a multi-level table is shown in Figure 59 below. The illustrated
example applies to pointer arrays, sort key tables and SEARCH key tables.
In the case of a list, level 0 contains the records themselves.
MODE IS CHAIN
ORDER IS
SORTED INDEXED
BY DATABASE-KEY
multi-level RSQ, PPP RSQ, act-key
sort key table
MODE IS CHAIN
ORDER IS
SORTED INDEXED
BY DEFINED KEYS
ASCENDING/
DESCENDING KEY IS...
multi-level key value,
RSQ, PPP
key value,
RSQ, act-key
SEARCH KEY IS...
USING INDEX
TYPE IS
REPEATED-KEY
(on set or record type
level)
multi-level key value,
RSQ, PPP
key value,
RSQ, act-key
SEARCH
key
table
SEARCH KEY IS...
USING INDEX
TYPE IS DATABASE-
KEY-LIST
multi-level see figure 60 and
figure 61
key value,
ACT_KEY
duplicates table
DDL/SSL clauses Table type Content of a table line:
Name of the
table
lowest level higher level
Table 21:Overview of the table types (part 2 of 2)