AQL Modifiers

The following AQL modifiers are presented:

any Modifier	Searches an entire item for a match, all attributes and all values.
break-on Modifier	Creates a visual break in output data when the value in the current output field is different from the previous value.
by Modifier	Designates a sort key, in ascending order, and must be followed by an attribute name.
by-dsnd Modifier	Designates a sort key, in descending order and must be followed by an attribute name.
by-exp Modifier	Designates a sort key, in ascending, exploded MultiValue order and must be followed by an attribute name.
by-exp-dsnd Modifier	Is followed by an attribute name that references a MultiValue attribute to be used individually as sort keys in descending order.
col-hdr-supp Modifier	Suppresses column heading above output columns and default page heading on AQL reports.
conv Modifier	Substitutes the specified conversion codes for attribute 7 of the specified Attribute-Defining-Item.
converting-nulls Modifier	Allows all values (including nulls) to be processed by the output-conversion.
dbl-spc Modifier	Double-spaces output by inserting a blank line between items.
det-supp Modifier	Suppresses the detail lines in a report.
dict Modifier	Specified immediately preceding a file name and affects the dictionary level of the specified file rather than the data section.
eval Modifier	Performs the operation in the specified expression on the specified Attribute-Defining-Items.
every Modifier	Forces comparison on every value, rather than any value.
fill Modifier	Forces listings into an across-the-page format if the listing would otherwise be noncolumnar.
fmt Modifier	substitutes the specified column heading, justification and width settings for attributes 3, 9 and 10 of the specified Attribute-Defining-Item.
footing Modifier	Designates a text string composed of literals and special options to output at the bottom of each page.
grand-total Modifier	Substitutes a string of text in place of the standard literal string normally output on the grand total line.
hdr-supp Modifier	Suppresses the default page heading (system time/date and page number) on output.
heading Modifier	Designates a text string composed of literals and special options to output at the top of each page.
id-supp Modifier	Suppresses the automatic display of item-IDs in the leftmost column of an AQL report.
ifno Modifier	Equivalent to using the with no or with not modifiers in an AQL sentence.
legend-supp Modifier	Suppresses the output of the legend on list and sort operations directed to the spooler.
locking Modifier	Locks an item for AQL report processing.
lptr Modifier	Directs output of AQL sentences to the system printer, via the spooler.
ni-supp Modifier	Suppresses the number of items listed message at the end of most AQL reports.
nopage Modifier	Prevents terminal output from pausing at the end of each page.
only Modifier	Ignores default attribute-defining items and displays only the item-IDs from the given file reference.
roll-on Modifier	Creates a visual break in output data when the value of a specified attribute changes.
sampling Modifier	Limits the number of items processed by the AQL sentence to a specific number.
show-nulls Modifier	Allows the display of empty multivalues.
ss Modifier	A connective that allows printing out AQL reports in spreadsheet format.
tape Modifier	Retrieves data from the currently attached tape, rather than the actual data level of the file.
tcl-supp Modifier	Suppresses the display of the AQL (TCL) sentence used to generate the report on printed output only.
total Modifier	Accumulates a columnar total for a specified attribute-defining item.
using Modifier	Allows AQL to report on the data in a given file using attribute-defining items from a different file.
with Modifier	Marks the beginning of a selection processor conditional, which is processed against the associated file to select items to pass on to the List processor.
within Modifier	Retrieves a list of all the items that are subitems of a specified item.
without Modifier	Negates the normal rules for selection criteria. Identical to if no, with no, and with not.
oconvs() Function	Performs conversions within an eval expression.
trans() Function	Performs translates within an eval expression.