AQL Commands

The following AQL commands are presented:

check-sum Command

Calculates a hexadecimal checksum for an attribute or an entire item and produces result as a list.

count Command

Produces a total of the number of items from an item list that meet the specified selection criteria.

hash-test Command

Produces a graphic representation of item-ID distribution within a given file, according to a test modulo provided.

istat Command

Produces a graphic representation of item-ID distribution within a file and suggests a new modulo.

list Command

Generates formatted output based upon the specified arguments.

list-item Command

Displays items in their internally stored format.

list-label Command

Produces one or more columns of output.

nselect Command

Selects items that do not match the selection criteria of a select.

reformat Command

Places values from the attributes specified in the command either in another file or to tape in the order in which they are presented.

select Command

Retrieves all items from the specified file reference that meet the optional selection criteria.

sort Command

Generates sorted and formatted output of selected items and attributes from a specified file.

sort-item Command

Displays items in their internally stored format, in order of the given sort-key.

sort-label Command

Produces one or more columns of output in order of the specified sort-key.

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).

sselect Command

Creates a sorted list of items from the specified file reference that meet selection criteria.

stat Command

Outputs the total number of items processed and an average value of all items that meet the specified selection criteria.

sum Command

Produces a numeric total of a given attribute for all items meeting the optional selection criteria.