SSL Placement
U929-J-Z125-9-76 169
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007 24. Oktober 2007 Stand 08:58.55 Pfad: G:\vogt\fsc\ud s\Manuale\en\udsent_e\uds ent.k05
Example
DDL: SET NAME IS CUSTOMER-ORDERS-PLACED
.
.
.
OWNER IS CUSTOMER.
MEMBER IS CUSTOMER-ORDER
.
.
.
SSL: RECORD NAME IS CUSTOMER-ORDER
PLACEMENT OPTIMIZATION FOR SET CUSTOMER-ORDERS-PLACED.
SET NAME IS CUSTOMER-ORDERS-PLACED
POPULATION IS 10
MODE IS POINTER-ARRAY ATTACHED TO OWNER
INDEX NAME IS SEARCH-TAB-C-ORD-PLCD
PLACING IS DETACHED.
In this example, UDS/SQL would arrange the records and table of the set as follows:
Figure 42: Placement of data based on the above definition
cust. 1 10-line
pointer array
10 orders
of cust. 1
10-line
SEARCH key table cust. 2
cust. 3
10-line
ptr. array
10 orders
of cust. 2
10-line
SEARCH key table . . .