EntitySets

Defines a unique name for a database file whose record structure is described by a series of fields.

EntName

The name of the EntitySet.

EntType

Defines the location of the EntitySet. If EntType is "ZIM" or blank then the EntitySet is under Zim's control. If the EntType is the name of a Server Access Module (SAM), then the EntitySet is under control of a database server.

AvgSize

The estimated number of records in the entity set. If you enter 0 or leave this field blank, Zim uses its internal default value.

DirName

The name of the Zim directory in which the EntitySet is created. If DirName is left blank, the EntitySet may be created in any Zim directory.

RemoteName

The name of the database table on the database server, if different than the EntitySet name. RemoteName is normally used when there is a naming incompatibility between Zim and the database server.

RemoteOwnerName

The name of the owner of the database table on the database server if the table is not owned by the user or included in his or her schema.

Notes

To establish an EntitySet, use this procedure:

  1. For each EntitySet that you require, add to the EntitySets EntitySet an entry containing appropriate information in each of the above fields.
  2. For each EntName, add one or more entries containing information about the fields in the entity set to the Fields EntitySet. Ensure that the DirName in the Fields entries is the same as the DirName in the EntitySets entry.
  3. When you are satisfied with the entry in EntitySets and the entries in Fields, use the CREATE command to create the EntitySet:

> create entityset entname [in dirname]

The attributes EntType, RemoteName, and RemoteOwnerName of an existing EntitySet can be modified with a "set" command instead of an "erase" command followed by a "create". Refer to the Zim commands topics.