access.options Definition/Access: Verbs

access.options

Command access.options Definition/Access: Verbs
Applicable release versions: AP, AP 6.1, AP 6.2, R83
Category Access: Verbs (152)
Description alter the behavior of Access 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 Access sentence, and must be preceded by a "(" (left parenthese). 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 Access options have an equivalent "modifier" or "connective". The modifier performs exactly the same function as the option, but requires a different syntax.

All macros that contain Access sentences allow the full complement of Access options to be passed into the macro for execution.
Syntax (options
Options b Suppresses the "number of items listed" message at the end of most Access reports. This is the same as the "j" option. See also "ni-supp" modifier. (AP only).

c Suppresses column headings above output columns as well as the default page heading on Access 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.

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 Access report. See also "id-supp" modifier.

j Suppresses the "number of items listed" message at the end of most Access reports. This is the same as the "b" option. See also "ni-supp" modifier. (AP only)

k Suppresses the output of the legend message for list and sort operations. See also "leg-supp" and "legend-supp" modifier. (AP only)

n Affects output to the terminal only, preventing the Access output from pausing at the end of each (terminal) page of output. See also "nopage" modifier.

p Directs output of the Access 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. (AP only)

s Suppresses the "number of items listed" message at the end of most Access reports. See also "ni-supp" modifier. (R83 3.1 only)

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. (AP only - list and sort only).

t{number} Displays a periodic update to the screen indicating the current progress of a select, sselect, or count. The approximate number of items selected followed by the approximate number of items scanned is displayed periodically. The period is a default of 100 items selected, but may be changed by appending a number after the "s" option. (AP 6.2 and above only - select, sselect, and count only).

w{-}{number} Displays the output of 'list' or 'sort' verb in a full screen window, allowing the user to scroll backward, foreward, 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 access 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 Access "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 Access pre-processor on releases 6.1 and higher.
Example
Purpose
Related tcl.options
access.lptr
access.t-dump
tcl.list-system-errors
access.modifiers
access.sselect
access.reformat
access.sreformat
access.sort
access.col-hdr-supp
access.sum
macros
tcl.listfiles
access.sort-label
access.within
access.fill
access.nopage
tcl.p.option
access.stat
access.connectives
access.ni-supp
access.y.option
access.z.option
tcl.list-pibs
tcl.cmdu
tcl.list-lists
access.list-label
tcl.list-abs
access.count
access.list-item
access.list
access.verbs
tcl.lfd
tcl.listdict
tcl.list-menus
tcl.list-macros
tcl.list-errors
access.istat
access.introduction
access.legend-supp
access.hdr-supp
access.id-supp
access.check-sum