Category: Data Handling

The Original Internet Language

Field Index

Indicates whether an index is to be maintained on the field. Valid Values As shown in the table below: Code Meaning No (DEFAULT) The field is not to be indexed Yes The field is to be indexed Unique The field is to be indexed, and each value found in the field must be unique Remarks Index is ignored for fields that…
Read more

Field ModTime

A time stamp indicating when it was created Remarks A time stamp indicating when it was created

Field 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. Remarks The name of the owner of the database table on the database server

Field 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. Remarks The name of the database table on the database server

Field RelPerUser

Whether this relationship is defined to be per user. Valid Values “yes” or “no” (the default value is “no”). Remarks The RelPerUser field only applies to Relationships with fields because there is no physical file to be handled. Normally, Relationships with fields belong to the database and are managed by ZimServer. However, per user Relationships…
Read more

Field EntPerUser

Whether this entity set is defined to be per user. Valid Values “yes” or “no” (the default value is “no”). Remarks Normally, entity sets belong to the database and are managed by ZimServer. However, per user entity sets have these differences: . They are handled by the current session and their information is lost after…
Read more

Field Virtual

Indicates whether the field is a virtual field. Valid Values As shown in the table below: Code Meaning No (DEFAULT) The field is a normal field Yes The field is a virtual field   Remarks A virtual field’s value is not stored in the database, but is computed dynamically, based on the expression entered into…
Read more

Field Reqd

“Non-null required” status of a field. Indicates whether a value other than $Null is always required for the field in an ADD or CHANGE command. Valid Values As shown in the table below: Code Meaning No (DEFAULT) The field need not be assigned a non-null value Yes The field must always be assigned a non-null…
Read more

Field DirName

The name of an application directory (Directories); otherwise, the one application directory in which the associated object may exist. Valid Values An 18-character string, containing a valid object name Remarks In Directories: DirName is the name assigned to the directory. In other Object Dictionary entity sets: In any entity set, the principal object’s DirName must…
Read more

Field BWSel

Index selectivity factors. Index selectivity factors used by Zim’s strategy optimizer. Valid Values A number from 0 to 1.000 (DEFAULT = 1.000) Remarks The index selectivity factors are relevant for indexed fields only. Each number represents the fraction of records that you would typically expect to retrieve using an indexed lookup with a particular operator…
Read more

en_CAEnglish