There are many keywords (also called connectives or modifiers) that may be included to expand INFO/ACCESS queries. A few have already been introduced in the preceding sections (for example, BY, HEADING, ID-SUPP and WITH).
Keywords may be used to:
Specify a comparison between attributes or between an attribute and a constant using relational operators such as GREATER THAN, EQUAL TO, and LESS THAN
Sort items in ascending or descending order according to data in one or more attributes
Format reports according to the user’s specifications for headings, footings, line spacing, and more
Retrieve and display items from backup medium
Print items on the line printer
Make a query more like a natural-language sentence
In order to use a keyword in an INFO/ACCESS query, there must be a corresponding entry for that keyword in the Master Dictionary. The table below lists the INFO/ACCESS keywords.
Keyword |
Option |
Description |
A, AN |
— |
Makes a query more English-like. |
ANY |
— |
Makes a query more English-like. |
AND |
— |
Joins selection expressions. |
AFTER |
— |
Greater Than. |
ARE |
— |
Makes a query more English-like. |
BEFORE |
— |
Less Than. |
BREAK-ON |
— |
Specifies breakpoints in a report. |
BY |
— |
Sorts the specified attribute in ascending order. |
BY-DSND |
— |
Sorts the specified attribute in descending order. |
BY-EXP |
— |
Separates items with MultiValued attributes into multiple items and sorts in ascending order. |
BY-EXP-DSND |
— |
Separates items with MultiValued attributes into multiple items and sorts in descending order. |
COL-HDR-SUPP |
(C) |
Suppresses time/date heading, column headings, and end-of-list message. |
DATA |
— |
Makes a query more English-like. |
DBL-SPC |
— |
Double-spaces items in the report. |
DET-SUPP |
(D) |
Will always suppress detail output. |
DICT |
— |
Specifies the dictionary part of a file. |
— |
(E) |
Allows user to end selection process by entering CTRL+X or ESC. |
EACH |
— |
Selects an item only if each value in a MultiValued attribute meets the specified condition. Used with WITH connective. |
EQUAL |
— |
Equal To. |
EVERY |
— |
Selects an item only if every value in a MultiValued attribute meets the specified condition. Used with WITH connective. |
— |
(F) |
Starts a new page for each item when used with the COPY, LIST-ITEM, and SORT-ITEM commands. |
FILE |
— |
Makes a query more English-like. |
FOOTING |
— |
Defines footer for report page. |
FOR |
— |
Makes a query more English-like. |
GE |
— |
Greater Than or Equal To. |
GRAND-TOTAL |
— |
Prints the specified text on the grand total line. |
GT |
— |
Greater Than. |
HEADING |
— |
Overrides default heading. |
[HDR-]SUPP |
(H) |
Suppresses default heading. |
ID-SUPP |
(I) |
Suppresses item-ID display. |
IF |
— |
Begins a selection expression. |
IN |
— |
Makes a query more English-like. |
ITEMS |
— |
Makes a query more English-like. |
— |
(L,n) |
Limits selected items to a maximum of n. |
LE |
— |
Less Than or Equal To. |
LIKE |
— |
Retrieves data that is phonetically similar to the specified criteria. |
LPTR |
(P) |
Sends output to printer. |
LT |
— |
Less Than. |
NE |
— |
Not Equal To. |
NO |
— |
Not Equal To. |
NOPAGE |
(N) |
Suppresses page pause. |
NOT |
— |
Not Equal To. |
OF |
— |
Makes a query more English-like. |
ONLY |
— |
Suppresses the default output specification and displays only item-IDs. |
OR |
— |
Joins selection expressions. |
— |
(Q) |
Makes surrounding double quotes mandatory for literal values. |
— |
(R) |
Displays a running count of selected items. |
SHOW-NULLS |
- |
Allows the display of empty multivalues. |
TAPE |
— |
Obtains data from backup medium. |
THE |
— |
Makes a query more English-like. |
TOTAL |
— |
Calculates and displays totals for the data in an attribute. |
USING |
— |
Specifies the dictionary to be used to interpret a file. |
WITH |
— |
Begins a selection expression. |
WITHIN |
— |
Retrieves and lists subitems of a specified item. Subitems are discussed in Using INFO/ACCESS Syntax. |
See Also