The following commands apply to describing data.

CHECK

Tests a Master File for common errors, diagrams the segments and relationships, and holds information from the Master File as a data file that you can query with the reporting language.

CREATE

Creates a new FOCUS or relational data source or erases data in an existing data source.

DECRYPT

Decodes an encoded Master File or FOCEXEC.

DEFINE

Creates temporary fields from expressions that use constants, mathematical and logical operators, and other real or temporary fields.

ENCRYPT

Encodes a Master File or FOCEXEC.

JOIN

Joins two data sources using one or more fields with common data or a test condition.

NODISP

Is a CRTFORM field attribute that you can use to suppress password display.

RESTRICT

Applies a new or changed DBA password to a data file.

SET MAXLRECL

Enables FOCUS to manage extra-long records.

SET USER

Sets a password for the FOCUS session.

SET PASS

Sets a user password.

USE

Specifies the name and/or location of FOCUS data sources.

Information Builders