Home > MultiValue Central > Online D3 Reference > Access: Verbs

Access: Verbs

Command Name Type Description
access.with Modifier Defines selection criteria in Access sentence.
access.phrases Definition master dictionary items which contain Access macros.
access.total Modifier Summates columnar total.
access.# Modifier 'not equal to' operator.
access.= Modifier 'equal to' operator.
access.a Modifier Throwaway connective.
access.after Modifier 'greater than' operator.
access.and Modifier 'and' (Boolean) operator.
access.any Modifier searches entire item for match, all attributes and values.
access.are Modifier Throwaway connective.
access.b.option Option Suppresses 'number of items listed' message.
access.before Modifier 'less than' operator.
access.break-on Modifier Creates control break in Access reports.
access.by Modifier Defines (ascending) sort key in Access sentence.
access.by-dsnd Modifier Defines descending sort key in Access sentence.
access.by-exp Modifier Explodes multi-values for sorting purposes.
access.by-exp-dsnd Modifier Explodes multi-values in descending sequence.
access.c.option Option The equivalent modifier is 'col-hdr-supp'.
access.c/total Modifier used by list-obj to display number of frames
access.check-sum Verb: Access Produces check sum total.
access.col-hdr-supp Modifier suppresses column and page headings on Access reports.
access.connectives Definition words in a master dictionary which are used to form the elements of Access statements.
access.converting-nulls Modifier Allows all values to be processed by the output conversion -- even nulls.
access.count Verb: Access Counts items in a file.
access.d.option Option Suppresses detail on Access reports.
access.data Modifier Throwaway connective.
access.dbl-spc Modifier Activates double spaced output.
access.default.output.specifications Definition selects the default attribute-defining items in an access sentence when none are explicitly provided.
access.det-supp Modifier Suppresses detail on Access reports.
access.dict Modifier Accesses dictionary level of specified file.
access.each Modifier Forces comparison on every value.
access.eq Modifier 'equal to' operator.
access.equal Modifier 'equal to' operator.
access.every Modifier Forces comparison on every value, rather than any value.
access.file Modifier Throwaway connective.
access.fill Modifier Displays report in 'across-the-page' mode.
access.footing Modifier Defines report footing.
access.for Modifier Throwaway connective.
access.ge Modifier 'greater than or equal to' operator.
access.grand-total Modifier Substitutes text for default '***' on grand total line.
access.gt Modifier 'greater than' operator.
access.h.option Option Suppresses default page heading.
access.hash-test Verb: Access Performs distribution analysis on file with test modulo.
access.hdr-supp Modifier suppress the header
access.header Modifier see 'heading'.
access.heading Modifier Defines report heading.
access.i.option Option Suppresses item-ids.
access.id-supp Modifier Suppresses item-ids.
access.if Modifier
access.ifno Modifier
access.in Modifier Throwaway connective.
access.introduction Introductory a Pick facility to retrieve and output data.
access.is Modifier
access.istat Verb: Access Performs distribution analysis on existing file modulo.
access.itemlist Definition Defines a specific list of item-ids.
access.items Modifier Throwaway connective.
access.j.option Option Suppresses 'number of items listed' message.
access.k.option Modifier supresses the legend.
access.le Modifier 'less than or equal to' operator.
access.leg-supp Modifier
access.legend-supp Modifier Suppresses 'legend' on output.
access.list Verb: Access Lists file.
access.list-item Verb: Access Displays item in storage format.
access.list-label Verb: Access Produces formatted labels.
access.logical.connectives Modifier Boolean operators used in selection clauses.
access.logical.operators Definition Relational operators used in selection clauses.
access.lptr Modifier Directs output to printer.
access.lt Modifier 'less than' operator.
access.m.option Option Allows all values to be processed by the output conversion -- even nulls.
access.modifiers Definition List of Access modifiers.
access.modifiers.modlist Definition Defines list of modifiers.
access.n.option Option Outputs report without pausing at the bottom of each page.
access.ne Modifier 'Not equal to' operator.
access.ni-supp Modifier Suppresses 'number of items listed' message.
access.no Modifier Reverses selection condition.
access.nopage Modifier Outputs report without pausing at the bottom of each page.
access.not Modifier Negates selection criteria.
access.nselect Verb: Access Performs 'not' select - only items not there.
access.of Modifier Throwaway connective.
access.only Modifier Displays item-ids only.
access.options Definition Standard options: b,c,d,h,i,j,k,n,p,r,s,u,y
access.or Modifier 'or' (Boolean) operator.
access.outlist Definition Defines list of attributes to output.
access.p.option Option Directs output to printer.
access.pre-processor Definition portion of Access which provides phrase parsing and eliminates the need for quotes around explicit values.
access.r.option Option Displays report in 'across-the-page' mode.
access.reformat Verb: Access Reformats data to file or tape.
access.relational.operators Relational Operator Relational operators used in selection clauses.
access.retrieval.scheme Definition Description of Access' sentence parser.
access.roll-on Modifier creates a visual 'break' in output data when the value of a specified attribute changes, an improvement over the 'break-on' command.
access.s-dump Verb: Access Dumps items to tape in sorted order.
access.sampling Modifier Limits the number of items processed to a given number.
access.select Verb: Access Creates list of items meeting specific criteria.
access.selection.criteria Definition Description of Access selection criteria.
access.sellist Definition Defines selection criteria portion of an Access sentence.
access.seqlist Definition Definies collation sequence.
access.sort Verb: Access Sorts file.
access.sort-item Verb: Access Sorts item(s) in storage format.
access.sort-label Verb: Access Produces formatted and sorted labels.
access.sreformat Verb: Access Reformats data in sorted order to file or tape.
access.ss Modifier Produces 'spreadsheet' summary of values by dates.
access.sselect Verb: Access Creates sorted list of items meeting specific criteria.
access.stat Verb: Access Displays total and average of numeric field.
access.string.searching Definition String searching.
access.sum Verb: Access Displays total of numeric field.
access.supp Modifier Suppresses default page heading.
access.t-dump Verb: Access Dumps items to tape.
access.t-load Verb: Access Loads data from t-dump format magnetic media.
access.tape Modifier Produces Access report from magnetic media.
access.tcl-supp Modifier Suppresses TCL command on printed output.
access.temporary.attribute.items Definition references any attribute by its numberic attribute count.
access.the Modifier Throwaway connective.
access.throwaway.connectives Modifier Access no-ops.
access.total-on Modifier see 'roll-on'.
access.use.of.quotes Definition How quotes work in Access.
access.user.exits Definition List of Access user exits.
access.using Modifier Uses dictionary from different file in an Access sentence.
access.verbs Definition General form of Access sentences.
access.within Modifier Retrieves sub-list from items.
access.without Modifier Same as with no or with not.
access.y.option Option Displays Access 'parsed' sentence parameters.
access.z.option Option Prints Access 'parsed' sentence parameters.
access.[ Modifier
access.] Modifier
access.^ Modifier
collation.order Definition Definition of collation order.
footing.options Definition Description of footing options.
heading.options Definition Description of heading options.
list.processor Definition Access output-processing facility.
tcl.el Verb: Access Edits saved list using Update processor.
tcl.istat Verb: Access produces a graphcal representation of item-id distribution and suggests a new modulo.
tcl.l Verb: Access Synonym for 'list'.
tcl.si Verb: Access Invokes 'sort-item' command.
ue.1070 User Exit Returns a checksum for the current item
ue.201e User Exit Returns the number of attributes in an item.
ue.2070 User Exit Returns the checksum value for the specified frame.
ue.3070 User Exit Returns PCB fid for the current process.
ue.5070 User Exit Converts a string in the form 'xxx' to the form 'xxx-000'.
ue.508e User Exit Calls the 'copy' processor from Access.
ue.6070 User Exit Inputs up to 100 characters.
ue.7070 User Exit Inputs up to 100 characters.
ue.8070 User Exit Returns a checksum for the current item
ue.9070 User Exit Toggles the Page/NoPage format.
ue.a070 User Exit Returns the specified value from a multi-valued set.
ue.c070 User Exit Returns the specified value from a multi-valued set.
wildcards Definition allows Access to search for strings beginning with, ending with, or containing a given string.
Back to Category Listing