Access Query Language

Access Query Language

The Access Query Language (AQL) is a D3 facility used to retrieve and output data. It is an original component of the D3 system and consists of the List pre-processor, the Select processor, and the Output processor. AQL is a system-level information retrieval language that allows users to query their database without writing complex programs.

AQL is a report-generating language that enables you to make various types of listings and queries. It is also used to select items from a file for use by other processors.

  1. Access Query Language overview
    AQL uses TCL commands and displays the results either on terminals or printers. AQL operates on specified files and items based on various optional criteria, specifications, modifiers, limiters, and options.
  2. AQL commands
    The following AQL commands are available.
  3. AQL modifiers
    The following AQL modifiers are available.
  4. AQL relational operators and logical clauses
    This section presents information for each of the AQL relational operators and logical clauses.
  5. Phrases
    Phrases must be defined in the dictionary of the file that the phrase is used (or in the account's master dictionary). Line one of the phrase definition must be an H. Line two of the phrase definition contains the words that make up the phrase.
  6. AQL user exits
    User exits allow direct access to system functions.