Modifiers control listing parameters such as double-spacing (dbl-spc), control breaks (roll-on or break-on), column totals (total), and suppression of item-IDs (id-supp), automatic headings (hdr-supp or col-hdr-supp), and default messages (ni-supp).
Other modifiers and options are listed below. For a detailed description of each connective, refer to the individual topics.
any break-on by by-dsnd by-exp by-exp-dsnd c/total col-hdr-supp conv converting-nulls det-supp dbl-spc dict |
each eval fill fmt footing grand-total hdr-supp heading id-supp ifno legend-supp lptr ni-supp |
nopage only roll-on sampling ss tape tcl-supp total using with within without |
Relational operators are modifiers used to establish criteria based on the relationship of data to fixed values or other data.
Operators are listed below. For a detailed description of each connective, refer to the individual topics.
after |
and |
before |
equal |
ge |
gt |
le |
lt |
ne |
no |
not |
or |
See Also
Access Query Language, Account, break-on Modifier, by Modifier, by-dsnd Modifier, by-exp Modifier, by-exp-dsnd Modifier, AQL Command Categories, converting-nulls Modifier, count Command, dbl-spc Modifier, det-supp Modifier, dict Modifier, fill Modifier, footing Modifier, grand-total Modifier, hdr-supp Modifier, id-supp Modifier, list Command, list-item Command, listconn Command, lptr Modifier, ni-supp Modifier, nopage Modifier, only Modifier, Options, sampling Modifier, sort Command, sort-label Command, stat Command, sum Command, tape Modifier, total Modifier, using Modifier, with Modifier, without Modifier