Changing a data set:

E Obsolete Database Utilities

Changing a data set:

The ALTER SET statement can be used to

change data set properties
add new data items to an existing data set
add a new index to an existing data set

ALTER SET SetIdent
{
[NAME = SetIdent; ]
[CAPACITY = number; ]

[ADD ITEM {
[Ident [(MasterSetIdent)]; ]
} ]

[ADD INDEX
Iident [/"collate"]; ]
}

SetIdent is the name of an existing data set, capacity is the capacity value.

Ident is an existing item name, the optional MasterSetIdent is the name of a master data set. A path can only be specified on new data sets.

Iident is an existing index item name, collate is the name of a collating sequence. The collating sequence name consists of a locale name and optional the modifier fold or nofold separated by an at (@) character. Please refer to the section "Collating sequences" for a description on collating sequences.

Changing Set properties

For example:

   ALTER SET Calls {
     NAME = TheCalls;
     CAPACITY = 0;
   }

This changes the data set name from Calls to TheCalls and the data set Capacity to zero.

Adding a data item

For example:

   ALTER SET Calls {
     ADD ITEM {
        Call-Id(Id);
        Date;
        Code;
        Call-Desc;
     }
   }

This adds four data items to the data set Calls. The Item Call-Id is used as a search item with an associated Master data set Id.

Adding an index

For example:

   ALTER SET Calls {
     ADD INDEX ICall-Id;
     ADD INDEX ICode / "german@fold";
   }

This will add two indices to data set Calls. The index ICode does use the collating sequence "german@fold".

Eloquence Database Manual - 19 DEC 2002