| only | Index Level | or |
| Syntax | (options |
| Category | Access |
| Type | Definition |
| Description |
alter the behavior of AQL sentences.
For example, the "list", "sort", "list-label" and "sort-label" verbs all use a standard output format which by default includes a standard page heading (time, date and page number), and the item-id of each item processed. "list" and "sort" additonally produce column headings above each output column and generate a "number of items listed" message at the end of the report. Options are always presented at the very end of an AQL sentence, and must be preceded by a "(" (left parenthesis). The ")" (right parenthesis) is optional. Multiple options may be specified. No delimiter is required between them. Some combinations of options are not valid. For example, it is unlikely that there would be a need for combining the "d", "i", and "c" options in the same sentence. Nearly every one of the standard AQL options has an equivalent "modifier" or "connective". The modifier performs exactly the same function as the option, but requires a different syntax. All macros that contain AQL sentences allow the full complement of AQL options to be passed into the macro for execution. |
| Options |
b Suppresses the "number of items listed" message at the end of most AQL reports. This is the same as the "j" option. See also "ni-supp" modifier.
c Suppresses column headings above output columns as well as the default page heading on AQL reports. See also "col-hdr-supp" modifier. d Suppresses the detail lines normally generated by the associated and encompassing list processor command. See also "det-supp" modifier. e Extended output. Forces columnar output irrespective of terminal width. This is useful for software parsing the output results of a query. h Suppresses the default page heading (system time/date and page number). See also "hdr-supp" or "supp" modifiers. i Suppresses the display of item-ids in the leftmost column of an AQL report. See also "id-supp" modifier. j Suppresses the "number of items listed" message at the end of most AQL reports. This is the same as the "b" option. See also "ni-supp" modifier. k Suppresses the output of the legend message for list and sort operations. See also "leg-supp" and "legend-supp" modifier. n Affects output to the terminal only, preventing the AQL output from pausing at the end of each (terminal) page of output. See also "nopage" modifier. p Directs output of the AQL sentence to the system printer, via the Spooler. See also "lptr" modifier. q Bypass utilization of indexes. r Forces listings into an "across the page" format, if the listing would otherwise be non-columnar. See also "fill" modifier. s Suppresses the normal action of attribute-defining items with an attribute-type of "w", thus preventing any embedded Output processor commands from being applied to the data being processed. (list and sort only). t{number} Displays a periodic total to the screen indicating the current progress of a select, sselect, or count. The number of items selected followed by the approximate number of items scanned is displayed periodically. The period is a default of 100 items scanned, but may be changed by appending a number after the "t" option. Note that a select which utilizes an index will NOT display a running total (select, sselect, and count only). Also note that if a simple "count" or "select" is done, the total counter may not be displayed at the rate of the specified period. w{-}{number} Displays the output of 'list' or 'sort' verb in a full screen window, allowing the user to scroll backward, forward, left and right through the report. If a minus sign "-" appears just after the w option, then a wide virtual display is used to display the output of the AQL statement. The user can then scroll left and right a screen at a time, as well as up and down a screen at a time. If a number is entered, that number of lines from the top of the first page are stored away as the header, and are displayed on each page. This may cause confusion for reports that display the page number within the header. The h option (hdr-supp) is automatically appended to any reports that do not include a heading statement. A short help screen is available while displaying the output to elaborate on the keystrokes. y The "y" option displays the AQL "compiled" string to the terminal. This string contains information about the attributes to display on the report in an internal representation for the list processor. If any attribute-defining items being output contain "A" (algebraic) processing codes, each one is translated into an "F" (function) processing code and the "F" code is displayed. z The "z" option disables the AQL pre-processor. |
| See Also | options: TCL lptr t-dump list-system-errors modifiers sselect reformat sreformat sort col-hdr-supp sum macros listfiles sort-label within fill nopage p stat connectives ni-supp y z list-pibs cmdu list-lists list-label list-abs count list-item list Access verbs lfd listdict list-menus list-macros list-errors istat Access legend-supp hdr-supp id-supp check-sum d m |
| Example | |
| Warnings | |
| Compatibility | D3 7.1 D3 7.0 |
| only | Index Level | or |