Query processor keywords

Query Processor Keywords

Top  Previous  Next

 

Field qualifiers

%Synonym for PERCENTAGE
ASDefine synonym for field and qualifiers
ASSOCInclude field in association
ASSOC.WITHAssociate two fields
AVERAGEReport average of field values
AVGSynonym for AVERAGE
BREAK.ONDefine field as breakpoint control item.
BREAK-ONSynonym for BREAK.ON
BREAK.SUPDefine field as non-displayed breakpoint control item.
BREAK-SUPSynonym for BREAK.SUP
CALCCalculate total of I-type item
CALCULATESynonym for CALC
COL.HDGSet column heading for displayed item
CONVSpecify conversion to be applied to field
CUMULATIVEReport cumulative value of field
DISPLAY.LIKEDisplay field using attributes of another field
DISPLAY.NAMESynonym for COL.HDG
ENUMSynonym for ENUMERATE
ENUMERATECount number of values in specified field
EVALDefines expression to be evaluated
FMTSpecify format for display of field
MAXReport maximum value of a field
MEDIANReport median value
MINReport minimum value of a field
MODEReport mode value
MULTI.VALUETreat field as multivalued
MULTIVALUEDSynonym for MULTI.VALUE
NO.NULLSSuppress null fields in MIN and AVG calculations
PCTSynonym for PERCENTAGE
PERCENTSynonym for PERCENTAGE
PERCENTAGEReport percentages
SINGLE.VALUETreat field as single-valued
SINGLEVALUEDSynonym for SINGLE.VALUE
TOTALReport total of field values

 

Selection clause options

FIRSTSynonym for SAMPLE
FROMProcess only records from given select list
REQUIRE.SELECTQuery must have an active select list
SAMPLEReport only specified number of records
SAMPLEDReport only a sample of records
SORTED.FIRSTSynonym for SORTED.SAMPLE
SORTED.SAMPLEReport only a specified number of records after sorting
WHENIntroduces multivalued field selection criteria
WITHIntroduces record selection criteria

 

SEARCH options

ALL.MATCHRecord must contain all given strings
FORSpecifies search strings on the command line
NO.CASECase insensitive option for SEARCH
NO.MATCHRecord must contain none of the given strings
STRINGSSpecifies a file and record containing the search strings

 

Selection clause operators used in WITH constructs

#Not equal. Synonym for NE
&Logical AND. Synonym for AND
<Less than. Synonym for LT
<Less than or equal to. Synonym for LE
<>Not equal. Synonym for NE
Equals. Synonym for EQ
=<Less than or equal to. Synonym for LE
=>Greater than or equal to. Synonym for GE
>Greater than. Synonym for GT
><Not equal. Synonym for NE
>Greater than or equal to. Synonym for GE
~Soundex matching. Synonym for SAID
AFTERGreater than   Synonym for GT
ANDLogical AND
BEFORELess than. Synonym for LT
BETWEENClosed range test
EQEquals
EQUALEquals. Synonym for EQ
GEGreater than or equal to
GREATERGreater than.  Synonym for GT
GTGreater than
INItem is in named list
LELess than or equal to
LESSLess than. Synonym for LT
LIKEPattern match
LTLess than
MATCHESPattern match. Synonym for LIKE
MATCHINGPattern match. Synonym for LIKE
NENot equal
NOTest for null field
NOTSynonym for NE
NOT.INItem is not in named list
ORLogical OR
SAIDSoundex matching
SPOKENSoundex matching. Synonym for SAID
UNLIKEInverse pattern match. Opposite of LIKE

 

Sort clause options

BYSort by ascending field value order
BY.DSNDSort by descending field value order
BY-DSNDSynonym for BY.DSND
BY.EXPAscending exploded multivalued sort
BY-EXPSynonym for BY.EXP
BY.EXP.DSNDDescending exploded multivalued sort
BY-EXP-DSNDSynonym for BY.EXP.DSND

 

Display options

BOXEDGenerates a boxed report on a PCL printer
CAPTIONSynonym for GRAND.TOTAL
COL.HDG.IDUse field names as default column headings
COL.HDR.SUPPSuppress page and column headings
COL.HDR.SUPSynonym for COL.HDR.SUPP
COL-HDR-SUPPSynonym for COL.HDR.SUPP
COL-HDR-SUPSynonym for COL.HDR.SUPP
COL.SPACESSpecifies inter-column spacing
COL.SPCSSynonym for COL.SPACES
COL.SUPSuppress column headings
COL-SUPPSynonym for COL.SUP
COUNT.SUPSuppress record count message at end of report
CSVSpecifies a comma separated delimited report
DBL.SPCOutput report with double line spacing
DBL-SPCSynonym for DBL.SPC
DELIMITERSpecifies delimited report
DET.SUPSuppress detail lines
DET-SUPPSynonym for DET.SUP
FOOTERSynonym for FOOTING
FOOTINGSpecify page footing
FORCEForce print of headings in empty report
GRAND.TOTALSpecify format for totals line
GRAND-TOTALSynonym for GRAND.TOTAL
HDR.SUPSuppress default page heading
HDR-SUPPSynonym for HDR.SUP
HEADERSynonym for HEADING
HEADINGSpecify page heading
ID.ONLYSuppress use of @ phrase
ID.SUPSuppress default inclusion of @ID in report
ID-SUPPSynonym for ID.SUP
LPTRDirect report to a printer
MARGINSpecify width of left margin
NEW.PAGEDisplay or print each record on a separate page
NO.PAGESuppress pause between displayed pages
NOPAGESynonym for NO.PAGE
NO.SPLITAvoid splitting a record across pages if possible
ONLYSynonym for ID.ONLY
OVERLAYSets a graphical page overlay
PANPan columns of a wide report
REPEATINGRepeats single valued items or the final value of a multivalued item
SCROLLAllow scrolling through report pages
STYLESets a report style
SUPPSynonym for HDR.SUP
VERTSynonym for VERTICALLY
VERTICALLYReport in vertical (one field per line) format
XMLReport in XML format

 

SELECT and SSELECT options

NO.NULLSIgnore null fields with SAVING option
SAVINGSave field value in place of record id
TOSpecifies target select list number
UNIQUEOmit duplicates with SAVING

 

Miscellaneous

ABSENT.IGNOREIgnore unfound records
ABSENT.NULLTreats an absent record as a null item rather than an error
DEFAULTParse the query using default option settings
LABELSpecifies the label template for LIST.LABEL and SORT.LABEL
LOCKINGTakes a file lock on the file being processed, preventing updates
NO.INDEXDo not use an alternate key index for record selection
REPORTINGDisplay periodic progress information during COUNT or SELECT with selection criteria
REQUIRE.INDEXDo not perform the query unless an alternate key index can be used
TOSpecifies the output file name for REFORMAT. See also CSV and DELIMITER
USINGUse an alternative dictionary