Previous Topic

Next Topic

Book Contents

Book Index

Multi-value indexes

You can define a multi-value index that contains more than one index value in an index within

A user can access an indexed page or line of a report using any of the multi-values.

The line of the report which contains several record level index values is highlighted, regardless of the value which is used for viewing.

For continued page or record level indexes, the page or line which has no index value is indexed by each of the multi-values of the previous page or line.

The M (multiple) subparameter is used to define the method of creation of a multi-value index.

Multi-value index from one range

To create a multi-value index from one range according to a mask, enter M=M (Mask). For more information refer to Example 7 in Examples.

More than one index or subindex value is created if more than one substring matching the MASK is found in the specified range. The relative INDEX COL parameter and MASK enclosed in asterisks are mandatory. The mask validation continues even if the appropriate value is found in the COL range.

Multi-value index from additional value ranges

To define additional value ranges for the multi-value index or subindex, specify M=A (And). For more information, refer to Example 8 in Examples.

The AND additional statements will appear after INDEX, SUBINDEX, or AND statements to define an additional range. It is possible to define one or more additional value ranges for the same index using M=A in the AND statement.

The index values are extracted from all INDEX or SUBINDEX ranges but all the subindex values defined under such statements are connected to all higher level values.

Multi-value index with separate subindex values

To define additional ranges in the value branch for the multi-value index with separate subindex values, specify M=T (Tree). For more information, refer to Example 9 in Examples.

The M=T parameter in INDEX or SUBINDEX statements defines the base full multi-value index tree if it appears the first time for the specific index and subindex in the decollation mission. The other M=T parameter for the same index on the same level defines additional value ranges connected to additional value branches. Low level values will be connected exactly to the higher level values from the same tree branch.

The base value branch may be combined with other regular indexes. The additional value branch should contain a part or all of the base branch indexes but shouldn't contain any regular index.

Parent Topic

DO INDEX: Decollating Parameter (decollating mission)