Fujitsu UDS/SQL V2.5 사용자 설명서
Placement
SSL
170
U929-J-Z125-9-76
5.4.3
Overview of placement statements
Type of
data
data
WITHIN
realm-
name,...
realm-
name,...
Member records in set with
LOCA-
TION
MODE IS
CALC
TION
MODE IS
CALC
Placement of the
records
OWNER
IS
SYSTEM
IS
SYSTEM
PLACEMENT
OPTIMIZA-
TION FOR SET
OPTIMIZA-
TION FOR SET
MODE
IS
...
IS
...
records
manda-
tory
tory
yes
yes
not permitted
no
LIST
ATTACHED
not
permitted
DETACHED
-
list in owner realm
DETACHED
WITHIN
WITHIN
-
list in DETACHED-
WITHIN realm
WITHIN realm
POINTER-
ARRAY
ARRAY
ATTACHED
not permitted
DETACHED
yes
hash area in WITHIN
realm
realm
no
in WITHIN realm
DETACHED
WITHIN
WITHIN
yes
hash area in WITHIN
realm
realm
no
in WITHIN realm
CHAIN
-
yes
in WITHIN realm
no
in WITHIN realm
no
yes
LIST
ATTACHED
-
list of owner
DETACHED
-
list of owner
DETACHED
WITHIN
WITHIN
not
permitted
POINTER-
ARRAY/
CHAIN
ARRAY/
CHAIN
-
yes
hash area (indirect
CALC) in WITHIN realm;
record of owner
CALC) in WITHIN realm;
record of owner
no
with owner
no
LIST
ATTACHED
-
list of owner
DETACHED
-
list in owner realm
DETACHED
WITHIN
WITHIN
-
list in DETACHED-
WITHIN realm
WITHIN realm
POINTER-
ARRAY/
CHAIN
ARRAY/
CHAIN
-
yes
hash area in WITHIN
realm
realm
no
in WITHIN realm
Table 8: Placement statements for records