Modifier

Synonyms

Description

#

NE, NOT

Synonym for the relational operator NOT EQUAL TO. See NE Operator for more information.

<

LT, BEFORE

Synonym for the relational operator LESS THAN. See LT Operator for more information.

<=

LE

Synonym for the relational operator LESS THAN OR EQUAL TO. See LE Operator for more information.

=

EQ, EQUAL

Synonym for the relational operator EQUAL TO. See EQ Operator for more information.

>

GT, AFTER

Synonym for the relational operator GREATER THAN. See GT Operator for more information.

>=

GE

Synonym for the relational operator GREATER THAN OR EQUAL TO. See GE Operator for more information.

A/AN

Throwaway connectives that can be used in an INFO/ACCESS query to make it sound more like an English-language sentence. They have no effect.

AFTER

GT, >

Synonym for the relational operator GREATER THAN. See GT Operator for more information.

AND

A logical connective used to specify multiple selection expressions. Specifies that all conditions must be met for an item to be selected. AND takes precedence over the OR connective when both appear in the same query. A maximum of nine AND clauses can be included in a single INFO/ACCESS query.

ANY

A throwaway connective that can be used in an INFO/ACCESS query to make it sound more like an English-language sentence. It has no effect.

ARE

A throwaway connective that can be used in an INFO/ACCESS query to make it sound more like an English-language sentence. It has no effect.

BEFORE

<, LT

Synonym for the relational operator LESS THAN. See LT Operator for more information.

BREAK-ON

An output modifier used with LIST and SORT commands that specifies which attribute is to be used to create breaks within a report. A control break (indicated by three asterisks or by user-specified text) occurs when the data for the specified attribute changes.

BY

A modifier that sorts items in ascending order by comparing the ASCII values of data in the specified attribute. The designated attribute is called a sort-key. Multiple BY clauses can be included in an INFO/ACCESS query to specify primary and secondary sort-keys. The sort-keys are processed from left to right.

BY-DSND

A modifier that sorts items in descending order. The designated attribute is called a sort-key. Multiple BY-DSND clauses can be included in an INFO/ACCESS query to specify primary and secondary sort-keys. The sort-keys are processed from left to right.

BY-EXP

A modifier that first separates values in a MultiValued attribute and then sorts them in ascending order. EXP stands for exploded, meaning that each value in the MultiValued attribute is sorted separately.

BY-EXP-DSND

A modifier that first separates the values in a MultiValued attribute and then sorts them in descending order. EXP stands for exploded, meaning that each value in the MultiValued attribute is sorted separately.

C

COL-HDR-SUPP

An option that suppresses the printing of the default page heading (page, time, and date), column headings, and end-of-list message (COL-HDR-SUPP).

COL-HDR-SUPP

C

An output modifier that suppresses the printing of the default page heading (page, time and date), column headings, and end-of-list message.

D

DET-SUPP

An option that suppresses detail lines in INFO/ACCESS statements (DET-SUPP).

DATA

A throwaway connective that can be used in an INFO/ACCESS query to make it sound more like an English-language sentence. It has no effect.

DBL-SPC

An output modifier that double-spaces between items in a report. Values in MultiValued attributes are single-spaced.

DET-SUPP

D

An output modifier that suppresses detail lines when it is used in a query that contains the BREAK-ON or TOTAL modifiers. Only break lines are displayed.

DICT

A selection modifier that generates a report from the file dictionary rather than the data file. DICT must be specified immediately before the file name in an INFO/ACCESS query.

E

An option that allows termination of the selection process by typing CTRL+X or by pressing ESC. When the selection is ended, all selected items are returned.

EACH

EVERY

A selection modifier that selects an item only if every value in a MultiValued attribute meets the specified condition. EACH must be specified immediately after the WITH modifier.

EQ

EQUAL, =

The relational operator EQUAL TO, used in selection expressions to compare an attribute to a constant or to another attribute.

EQUAL

EQ, =

Synonym for the relational operator EQUAL TO. See EQ Operator for more information.

EVERY

EACH

A selection modifier that selects an item only if every value in a MultiValued attribute meets the specified condition. EVERY must be specified immediately after the WITH modifier.

F

An option that generates a form-feed for each item.

FILE

A throwaway connective that can be used in an INFO/ACCESS query to make it sound more like an English-language sentence. It has no effect.

FOOTING

An output modifier that defines a footing for the bottom of each page of a report.

FOR

A throwaway connective that can be used in an INFO/ACCESS query to make it sound more like an English-language sentence. It has no effect.

GE

>=

The relational operator GREATER THAN OR EQUAL TO, used in selection expressions to compare an attribute to a constant or to another attribute.

GRAND-TOTAL

An output modifier that specifies text to be printed on the Grand Total line of a report. The specified text is printed left-justified in the first column of the report, replacing the three asterisks that normally appear.

GT

>, AFTER

The relational operator GREATER THAN, used in selection expressions to compare an attribute to a constant or to another attribute.

H

HDR-SUPP, SUPP

An option that suppresses the printing of the default page heading (page, time, date) and the end-of-list message (HDR-SUPP).

HDR-SUPP

H, SUPP

An output modifier that suppresses the printing of the default page heading (page, time, date) and the end-of-list message. When used with the T-DUMP, S-DUMP, or T-LOAD commands, HDR-SUPP suppresses display of the backup medium label.

HEADING

An output modifier that defines a heading to replace the default heading for the top of each page of a report.

I

ID-SUPP

An option that suppresses printing of item-IDs in a report (ID-SUPP). See ID-SUPP Modifier for more information.

ID-SUPP

I

An output modifier that suppresses the display of item-IDs in a report. Without this keyword, item-IDs automatically appear as the first column in a report in addition to the attributes explicitly specified in the INFO/ACCESS query.

IF

WITH

Synonym to selection modifier WITH. See WITH Modifier for more information.

IN

A throwaway connective that can be used in an INFO/ACCESS query to make it sound more like an English-language sentence. It has no effect.

ITEMS

A throwaway connective that can be used in an INFO/ACCESS query to make it sound more like an English-language sentence. It has no effect.

L,n

An option that limits the number of items selected by an INFO/ACCESS sentence to n. The L option is useful for generating sample data (for instance, when setting up report layouts).

LE

<=

The relational operator LESS THAN OR EQUAL TO, used in selection expressions to compare an attribute to a constant or to another attribute.

LIKE

A connective that selects items with a data element that sounds like the specified constant. The LIKE connective converts an alphabetic text string into a phonetic equivalent based on a Soundex algorithm.

LPTR

P

An output modifier that sends a report to the line printer instead of to the screen.

LT

<, BEFORE

The relational operator LESS THAN, used in selection expressions to compare an attribute to a constant or to another attribute.

N

NOPAGE

An option that suppresses automatic paging on the terminal (NOPAGE).

NE

#, NOT

The relational operator NOT EQUAL TO, used in selection expressions to compare an attribute to a constant or to another attribute.

NO

WITHOUT

A relational operator that selects items with a null value for a specified attribute.

NOPAGE

N

A modifier that suppresses pagination so that a report scrolls continuously up the screen.

NOT

#, NE

Synonym for the relational operator NOT EQUAL TO. See NE Operator for more information.

O

An option used with the T-LOAD command to overwrite an existing item.

OF

A throwaway connective that can be used in an INFO/ACCESS query to make it sound more like an English-language sentence. It has no effect.

ONLY

An output modifier that suppresses the default output specifications for a file and displays the item-IDs only. It must immediately precede the file name in an INFO/ACCESS query.

OR

A logical connective used to join multiple selection expressions. OR specifies that only one of the specified conditions must be met for an item to be selected.

P

LPTR

An output modifier that sends a report to the line printer instead of to the screen.

Q

An option that suppresses the need to enclose item-IDs and attribute values in quotes.

R [,n]

An option that maintains a running count of items that match selection criteria. n specifies that the display be updated only every nth item.

SHOW-NULLS

An output modifier that allows the display of empty multivalues.

SUPP

H, HDR-SUPP

Synonym to H and output modifier HDR-SUPP. See HDR-SUPP Modifier for more information.

T

An option that sends output to the terminal (the default).

TAPE

A selection modifier that retrieves and displays items from a T-DUMP tape. TAPE can be used only with the LIST, LIST-LABEL, LIST-ITEM, SUM, STAT, ISTAT, HASH-TEST, and COUNT commands.

THE

A throwaway connective that can be used in an INFO/ACCESS query to make it sound more like an English-language sentence. It has no effect.

TOTAL

An output modifier that calculates and displays totals for numeric attributes. It must be placed immediately before the name of the attribute to be totalled.

USING

A connective that generates a report using the Attribute Definition items in a specified dictionary rather than the data file's own dictionary.

WITH

IF

A selection modifier that introduces a selection expression.

WITHIN

A connective that retrieves subitems from a specified item.

WITHOUT

NO, WITH NO

Synonym to relational operator NO. See NO Operator for more information.

WITH NO

NO, WITHOUT

Synonym to relational operator NO. See NO Operator for more information.

X

An option used only with the COPY-LIST command to display data in hexadecimal format. This is useful for displaying nonprintable characters.

Y

An option that displays translation of A-correlative DICT entries. This is useful as a debugging tool.