E Obsolete Database Utilities

Changing data item definition

ALTER IITEM Ident {
[NAME = Iident;]
[TYPE = Ident[:length] ...;]
}

Iident is a new index item name, Ident is an existing item name and the optional length clause specifies an 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 (,).

For example:

  ALTER IITEM ICall-Id {
    NAME = IX-Call-Id;
    TYPE = Call-Id;
  }
This changes the index item name from ICall-ID to IX-Call-Id and defines that the index is built using the value of the data item Call-Id.

Eloquence Database Manual - 19 DEC 2002