Reserved keywords

ACL reserves the keywords listed in Table 1 for special purposes. You cannot name fields or variables with these reserved keyword values, or with the first letter(s) of these reserved keywords. For example, a field named A is invalid because it conflicts with AS, and a field named REC conflicts with RECORD. But a field named ASK is valid because it cannot be confused with AS.

Table 1. ACL reserved keywords

Reserved Keyword

Description

ALL

Refers to all previously defined fields.

AND

Refers to the logical AND operator.

AS

Allows the output field or expression to be given a name (which must be specified in quotes).

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.

FIELDS

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

IF

Specifies a filter condition.

LINE

Used by the DEFINE COLUMN command to specify whether a field breaks over a specified number of lines. If not specified, the field defaults to a single line.

NODUPS

Blanks out the repetition of blank key fields in a report.

NOT

Refers to the logical NOT operator.

NOZEROS

Causes zero values in a numeric field or report to be printed or displayed as blank.

ON

Precedes a field list.

OR

Refers to the logical OR operator.

OTHER

Indicates which fields or expressions to include, but not accumulate, in the output of the SUMMARIZE command. ACL selects the specified fields or expressions from the first record that it encounters.

PAGE

Is used by the REPORT command to signal a page break after a certain level.

PICTURE

Specifies a format for a numeric field.

PRIMARY

An optional parameter in the JOIN command that 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

An optional parameter in the JOIN command that specifies a certain type of join.

SUPPRESS

Blocks the output of numeric totals.

T

Refers to the true value of a logical expression.

TO

Designates an output file for any command.

WIDTH

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



(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback