Fujitsu UDS/SQL V2.5 사용자 설명서

Reference section

U929-J-Z125-9-76

  

249

D

ok

us

c

h

abl

on

en

 1

9x

24 V

e

rs

ion

 7

.3

us

 f

ü

r F

ram

eM

ak

er

 V

7

.x

v

o

m

 1

4.

02

.2

00

7

©

 c

o

gni

tas

 Gm

b

H

 20

01-

20

07

18

. Ok

tobe

r 20

07

  S

ta

nd

 1

1:

29

.5

2

P

fa

d:

 G

:\

v

og

t\

fs

c

\ud

s

\M

anu

al

e

\e

n\

ud

s

e

nt

_e\

u

ds

ent

.k

0

9

 
   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                                    MU]]...

                    

                                                  

                    

⎩  [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.