
Chapter 3. Database enhancements 93
Example 3-18 DBDGEN statements for multi secondary index segments
LCHILD NAME=(sisegname,sidbname),PTR=SYMB,MULTISEG=YES
XDFLD ..................NULLVAL=value1
Multiple secondary index segments are defined by including multiple LCHILD and XDFLD
statement pairs in the indexed database (Figure 3-18).
The LCHILD segment must include the MULTISEG=YES parameter. MULTISEG=NO is the default
for this parameter.
The NULLVAL= parameter is useful for avoiding the creation of secondary indices without a
value. With this parameter, you suppress the creation of index pointer segments when the
index source segment data used ...