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. |
