Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

Data

Specifies a list of properties whose values are to be stored within this index.

Usage

To store values of properties within an index, use the following syntax:

Index name On property_expression_list [ Data = stored_property_list ];

Where stored_property_list is either a single property name or a comma-separated list of properties, enclosed in parentheses.

Details

This keyword specifies a list of properties whose values are to be stored within this index.

You cannot use this keyword with a bitmap index.

Refer to the documentation on indices for more details.

Default

If you omit this keyword, values of properties are not stored within the index.

Example

Index NameIDX On Name [ Data = Name ];

Index ZipIDX On ZipCode [ Data = (City,State) ];
Copy code to clipboard

See Also