check-sum command 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.
count command The count command produces a total of the number of items that meet the selection criteria as determined by the item.list and selection.criteria specification.
hash-test command 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.
istat command The istat command produces a graphic representation of item-ID distribution within a file and suggests a new modulo. The istat command is equivalent to the hash-test command.
list command 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.
list-item command (Access Query Language) 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.
list-label command The list-label command produces one or more columns of output.
nselect command 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.
reformat command The reformat command takes values from the attributes specified in the command and places them either in another file or to tape in the order in which they are presented.
select command 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.
sort command 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.
sort-item command 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.
sort-label 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.
sreformat command 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).
sselect command The sselect command creates a sorted list of items from the specified file reference that meet selection criteria.
stat command The stat command outputs the total number of items processed and an average value of all items that meet the specified selection criteria.
sum command 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.