Reserved keywords

Analytics reserves certain keywords for special purposes. You cannot name fields or variables with these reserved keyword values.

If you add a suffix to a reserved keyword, then you can use it as a field or variable name. For example, the name "Field" is not permitted, but "Field_1" or "Field_2" are permitted.

Note

In some cases, you are also prevented from using abbreviations of the reserved keywords, such as "Can" (CANCEL), "Form" (FORMAT), or "Rec" (RECORD).

Reserved Keyword Purpose in Analytics
ALL Refers to all previously defined fields.

AND

The logical AND operator.

AS

Assigns a display name to the output field or expression.

AXRunByUser A system variable that stores the username of the user running an analytic script on AX Server in the format "domain\username".

CANCEL

Cancels the current command.

D

Specifies a descending sort order for the preceding expression or field name.

END

Concludes the input stream and acts like a null line.

EXPR

The prefix for the name of a default output field.

F

Refers to the false value of a logical expression.

FIELD/FIELDS

Part of the EXPORT, EXTRACT, JOIN, and SAMPLE commands.

FORMAT

An older name for an Analytics table layout.

Cannot be used as a name for an Analytics table.

IF

Specifies a condition.

LINE

Used by the DEFINE COLUMN command to specify whether a field breaks over a specified number of lines.

NODUPS

Suppresses duplicate display values in the break field in an Analytics report.

NOT

The logical NOT operator.

NOZEROS

Displays or prints zero values in a numeric field or report as blank.

ON

Precedes a field list.

OR

The logical OR operator.

OTHER

Indicates which fields or expressions to include, but not subtotal, in the output of the SUMMARIZE command.

PAGE

Used by the REPORT command to create page breaks.

PICTURE

Specifies a format for a numeric field.

PRIMARY

Specifies a certain type of join.

RECORD

Refers to the entire input record as it exists.

RECORD_LENGTH

Stores record-length values for use in record-processing operations.

SECONDARY

Specifies a certain type of join.

SUPPRESS

Suppresses the output of numeric totals.

T

Refers to the true value of a logical expression.

TAPE

Refers to an older method of accessing data with Analytics.

Cannot be used as a name for an Analytics table.

TO

Designates an output file for any command.

WIDTH

Changes the default print width of a specified field or expression.

Analytics 14.1 Help