E Obsolete Database Utilities

Creating a new data set

CREATE SET SetIdent type {
Ident [(MasterSetIdent)];
...
}

SetIdent is the name of a new data set, type is the data set type.

The optional MasterSetIdent is the name of a master data set.

Type must be one of:

M or MASTER

Master data set

A or AUTOMATIC

Automatic data set

D or DETAIL

Detail data set

For example:

  CREATE SET Calls, D {
    Call-Id(Id);
    Call-Date;
    Call-Desc;
  }
This creates the new detail data set Calls containing the data items Call-Id, Call-Date and Call-Desc.

The data item Call-Id is used as a search item with the master set Id.

Eloquence Database Manual - 19 DEC 2002