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

Reference section

254

  

 U929-J-Z125-9-76

 
   SET NAME IS set-name

       [POPULATION IS integer-1[ INCREASE IS integer-2]]

                

⎧CHAIN[ LINKED TO PRIOR]                         ⎫

                

                                                

                

⎧POINTER-ARRAY⎫ ⎧ATTACHED TO OWNER             ⎫

       [MODE IS 

⎨                                                ⎬]

                

⎨             ⎬ ⎨DETACHED[ WITHIN realm-name-1]⎬

                

                                              

                

⎩⎩LIST         ⎭ ⎩        [ WITH PHYSICAL LINK] ⎭⎭

       [DYNAMIC REORGANIZATION SPANS integer-3 PAGES]

       [INDEX NAME IS name

                       

⎧ATTACHED TO OWNER             ⎫

           [PLACING IS 

⎨                              ⎬]

                       

⎩DETACHED[ WITHIN realm-name-2]⎭

                    

⎧DATABASE-KEY-LIST                                ⎫

                    

                                                 

           [TYPE IS 

⎨REPEATED-KEY                                     ⎬]]...

                    

                                                 

                    

⎩   [DYNAMIC REORGANIZATION SPANS integer-4 PAGES]⎭

       [MEMBER IS PHYSICALLY LINKED TO OWNER].
 

The set entry is used to specify the set to which the storage structure description applies 
as well as 

–

to indicate the average size of the set occurrences 

–

to give information on the connection of the records within the set occurrences 

–

to define placement and extent of reorganization for pointer arrays, lists, sort key tables 
and set SEARCH key tables 

–

to indicate the type of set SEARCH key tables 

–

to add a pointer from member to owner. 

The individual clauses of the set entry are explained below.