E Obsolete Database Utilities

Creating a new index item

CREATE IITEM
Iident = Ident[:length ] ...;

CREATE IITEM {
Iident = Ident[:length ] ...;
...
}

Iident is a new index item name, Ident is an existing item name and the optional length clause specifies a different index segment length. The index item name may not be defined as an item. Up to 7 index segments can be specified, separated by a comma (,).

If enclosed in curly braces, multiple index items can be defined.

For example:

   CREATE IITEM
     ICall-Id = Call-Id;
This defines a new index item named ICall-Id using the value of the data item Call-Id.

   CREATE IITEM
      ICall-Id = Call-Date, Call-Id;
This defines a new index item named ICall-Id combining the items Call-Date and Call-Id.


Eloquence Database Manual - 19 DEC 2002