The check-sum command calculates a hexadecimal checksum for a specified attribute, or the entire item if no attribute is specified, and produces result as a list. The checksum statistics change whenever a file is updated, providing a means to determine if a file has been changed.
The hash-test command produces a histogram, or graphic representation of item-ID distribution within a given file, according to a test modulo provided. The command is useful when performing file reallocation, providing insight into how the item-IDs hash into the file, as well as providing a suggested modulo.
The list command generates formatted output based upon the specified arguments. If an item list is specified, items are listed in order of the item-IDs in the item list. If an item list is not specified, items are listed by the groups into which they hash, and within each group, each item is listed in the order in which it was entered or most recently updated.
The list-item command displays items in their internally stored format. The list-item command combines the action of the copy command with the selection criteria and format capabilities of the list command. The items are copied to the user’s terminal or to the printer just as the copy command would copy them, with the line numbers on the left margin.
The nselect command selects items that would fail the selection criteria of a select. When an output list displays in any of the various select sentences, the list is built from the contents of the specified attribute.
The select command retrieves all items from the specified file reference that meet the optional selection criteria. The items are selected in the order of their appearance in the file reference. The selected item may be saved for future use or acted upon immediately.
The sort command generates sorted and formatted output of selected items and attributes from a specified file. The output produced by sort is identical to the output produced by list when the by modifier is specified. The default sort sequence can be altered by using the ms processing code (see ms (Mask Alter Sort) processing code for more information.
The sort-item command displays items in their internally stored format, in order of the given sort-key. The sort-item command combines the action of the copy command with the selection criteria and format capabilities of the sort command.
The sort-label command produces one or more columns of output in order of the specified sort-key. The sort-label command outputs formatted labels or reports in columnar format from the specified file reference, sequenced by one or more sort-key.
The sreformat command moves the sorted values from the attributes specified in the AQL sentence and places them either in another file or to tape in the order of the specified sort key (specified in sort.criteria).
The sum command produces a numeric total of a given attribute for all items meeting the optional selection criteria. If an attribute name (attribute name or number) is not specified, the total number of characters in the selected items are calculated. If only the file reference is specified, the total number of characters in the entire file is calculated, including attribute and value marks.