Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Reference section SSL
U929-J-Z125-9-76 249
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
18. Oktober 2007 Stand 11:29.52 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k09
9.2.2 Record entry
RECORD NAME IS record-name
[DATABASE-KEY-TRANSLATION-TABLE[ IS integer-1][ WITHIN realm-name-1]]
[POPULATION IS {integer-2 WITHIN realm-name-2},...]
[PLACEMENT OPTIMIZATION FOR SET set-name]
[INDEX NAME IS name
[PLACING IS WITHIN realm-name-3]
DATABASE-KEY-LIST
[TYPE IS REPEATED-KEY ]]...
[DYNAMIC REORGANIZATION SPANS integer-3 PAGES]
[COMPRESSION FOR ALL ITEMS].
The record entry is used to specify the name of the record type to which the storage
structure description applies and
to describe the size and physical position of the DBTT and the size of the hash areas
for record SEARCH keys,
to specify the number of records of the record type or the size of the hash area for the
primary key within certain realms,
to describe the physical position of the records within a realm if the record type is a
member of a set,
to describe the physical position, the type and the extent of reorganization employed for
record SEARCH key tables or the physical position of hash areas for record SEARCH
keys, and
to indicate compression.
The individual clauses of the record entry are explained below.
RECORD NAME IS record-name
This clause is used to specify the name of the record type to which the record entry applies.