Master File Attributes

Reference:

The following sections list the attributes supported in a Master File.

Reference: Master File FILE Attributes

ACCESS

Identifies the Access File for a FOCUS data source.

DATASET

Identifies the fully-qualified physical file name.

FILENAME

Identifies the Master File.

REMARKS|DESC[RIPTION]

Provides descriptive text in the default language.

DESC_ln

Provides descriptive text in a language identified by the language code ln.

SUFFIX

Identifies the type of data source.

Reference: Master File Segment Attributes

DATASET

Identifies the fully-qualified physical file name of a LOCATION or cross-referenced segment in a FOCUS data source.

ENCRYPT

Causes the data values for a segment to be encoded as they are added to the database.

LOCATION

Names a separate file where a segment of data or a text field is located.

OCCURS

Identifies repeating fields.

PARENT

Identifies a segment's parent segment.

POSITION

Names a field in the parent segment that acts as a place holder for repeating fields in the middle of a record.

SEGNAME

Assigns a segment name.

SEGTYPE

Declares the sort order and number of key fields in a segment.

Reference: Master File Field Attributes

ACCEPT

Assigns a list or range of acceptable data values to a field, or identifies a file in which acceptable values are stored. The values are used to test transaction values during data maintenance operations. For files with multiple record types described by a generalized record structure, ACCEPT assigns valid RECTYPE data values.

ACTUAL

Declares the type and length of a field in a non-FOCUS data source.

ALIAS

Assigns an alternate field name. For relational databases, ALIAS is set to the field's column name. For non-FOCUS data source containing multiple record types, ALIAS is set to the value of the record type flag.

COMPUTE

Stores a temporary field definition in the Master File for use as a COMPUTE in a request.

DATEPATTERN

Provides a pattern for converting non-standard alphanumeric dates to FOCUS dates.

DEFINE

Creates a virtual field.

DESC

Provides descriptive text in the default language.

DESC_ln

Provides descriptive text in a language identified by the language code ln.

FIELDNAME

Assigns a field name.

FIELDTYPE

Identifies an indexed field.

FILTER

Defines a named boolean expression to use in WHERE or IF tests in a request.

FORMAT

Declares the type, length, and display options of a field in a FOCUS database. For other data files, declares how FOCUS is to display and use the data values.

GROUP

Describes multiple fields as a single entity.

ELEMENTS

Identifies group fields as a set of elements. Eliminates the need to specify USAGE and ACTUAL formats for the group field.

HELPMESSAGE

Assigns a one-line text message that can be displayed at the bottom of a CRTFORM screen.

INDEX

Same as FIELDTYPE.

LOCATION

Names a separate file where a segment of data or a text field is located.

MAPFIELD

Is a field in the fixed portion of a segment that contains the record type for a descendant OCCURS segment with record types.

MAPVALUE

Associates each OCCURS segment with its associated MAPFIELD record indicator.

MISSING

Causes FOCUS to distinguish null values from intentionally entered zeros or blanks.

ORDER

Declares an internal counter for an OCCURS segment that associates a sequence number with each repetition.

RECTYPE

Identifies the type of record in a non-FOCUS data source with multiple record types.

TITLE

Provides a column heading in the default language.

TITLE_ln

Provides a column heading in a language identified by the language code ln.

USAGE

Same as FORMAT.

Reference: Master File Attributes That Join Data Sources

CRFILE

Names the cross-referenced file in a Master-defined join.

CRKEY

Names the common field in a Master-defined join.

CRSEGNAME

Names the cross-referenced segment that contains the common field in a Master-defined join.

Reference: Master File Data Security Attributes

ACCESS

Specifies a user's access rights.

DBA

Establishes the administrator's password.

DBAFILE

Names a central file that contains security information.

END

Marks the end of the Master File.

NAME

Identifies the restricted segment or field.

RESTRICT

Controls Access to segments and fields

USER

Establishes a user's password.

VALUE

Defines the test condition.

Reference: Master File Hierarchy Attributes

PROPERTY

Identifies a field as a parent of the hierarchy field (PROPERTY=PARENT_OF) or a caption for the hierarchy field (PROPERTY=CAPTION).

REFERENCE

Identifies the hierarchy field.