# jQL Keyword Cross-Reference

Updated: 11/30/2021, 7:00:45 PM
Created: 11/30/2021, 7:00:45 PM
Last Updated By: Jake Tuttle
Read Time: 9 minute(s)

Keyword Description
! Synonym for Logical OR
# Synonym for NE
% Synonym for PERCENTAGE
& Synonym for AND
( Left parenthesis
) Right parentesis
* Asterisk, used in multiplication
+ Plus sign, used in addition
- Minus sign, used in subtraction
/ Backslash, used in division
< Synonym for LT
<= Synonym for LE
<> Synonym for NE
= Synonym for EQ
=< Synonym for LE
=> Synonym for GE
> Synonym for GT
>< Synonym for NE
>= Synonym for GE
A Throwaway
AFTER Synonym for GT
ALL Use with CLEARSELECT to clear all select lists
AN Throwaway
AND Logical AND
ANY Throwaway
ARE Throwaway
AS Field qualifier for synonyms
ASSOC Field qualifier for named associations
ASSOC.WITH Associate two fields
ASSOCIATED Synonym for ASSOC.WITH
ASSOCIATION Synonym for ASSOC
AVERAGE Show average of field values
AVG Synonym for AVERAGE
BEFORE Synonym for LT
BETWEEN Range test
BREAK-ON Specify a break point
BREAK-SUP Define a non-displayed break control item
BREAK.ON Synonym for BREAK-ON
BREAK.SUP Synonym for BREAK-SUP
BSELECT Creates a select list based on output specifications.
BY Sort by ascending field value
BY-DSND Sort by descending field value
BY-EXP Exploded multi-value sort ascending
BY-EXP-DSND Exploded multi-value sort descending
BY.DSND Synonym for BY-DSND
BY.EXP Synonym for BY-EXP
BY.EXP.DSND Synonym for BY-EXP_DSND
CALC Calculate totals on I-type items
CALCULATE Synonym for CALC
CAPTION Synonym for GRAND-TOTAL
CLEARSELECT Clear a SELECT list
CNV Synonym for CONV
COL-FILLER
COL-HDR-SUPP Suppress printing of default page heading and column headings
COL-SPACES Define inter-column spacing
COL-SUPP Suppress all column headings
COL.HDG Define an alternative column heading
COL.HDR Synonym for COL.HDG
COL.HDR.SUPP Synonym for COL-HDR-SUPP
COL.SPACES Synonym for COL-SPACES
COL.SPCS Synonym for COL-SPACES
COL.SUP Synonym for COL-SUPP
CONV Specify an alternative conversion for a field
COUNT Counts records.
COUNT-SUPP Synonym for NI-SUPP
COUNT.SUP Synonym for NI-SUPP
COUNT.SUPP Synonym for NI-SUPP
DATA Throwaway
DBL-SPACE Set double-spacing between lines on a report/query
DBL-SPC Synonym for DBL-SPACE
DBL.SPC Synonym for DBL-SPACE
DEFAULT
DET-SUPP Suppress reporting of detail lines
DET.SUP Synonym for DET-SUPP
DICT Indicates that the DICT of a file is to be queried
DISPLAY.LIKE Display a field using the attributes of another field
DISPLAY.NAME Synonym for COL.HDG
DISPLAYLIKE Synonym for DISPLAYLIKE
DISPLAYNAME Synonym for COL.HDG
EACH Selection qulaifier
EDELETE Deletes selected records from a file.
END Synonym for CLEARSELECT
ENUM Count the number of values which occur in a field
ENUMERATE Synonym for ENUM
EQ Equals
EQUAL Synonym for EQ
ESEARCH Searches records for specified strings.
EVAL Define an I-type expression to be evaluated
EVERY Synonym for EACH
FILE Throwaway
FIRST Synonym for SAMPLE
FMT Specify an alternate output format for a field
FOOTER Synonym for FOOTING
FOOTING Specify page footing for a report
FOR Throwaway
FROM Process records from specified select list
GE Greater than or equal to
GRAND-TOTAL Specify format of totals line
GRAND.TOTAL Synonym for GRAND-TOTAL
GT Greater than
HDR-SUPP Suppress the display of HEADER information
HDR.SUP Synonym for HDR-SUPP
HEADER Synonym for HEADING
HEADING Define page heading
I-DUMP Outputs the entire contents of items.
ID.ONLY Only display item ID's
ID-SUPP Suppress the display of item ID
ID.SUP Synonym for ID-SUPP
ID.SUPP Synonym for ID-SUPP
IF Synonym for WITH
IN Throwaway
INQUIRING Prompt for item ID's in query
INVISIBLE Throwaway
ITEMS Throwaway
LE Less than or equal to
LIKE Pattern matching
LIST4 List Item IDs of a file in two or four columns
LIST Generates a formatted report of records and fields from a specified file.
LIST-ITEM Outputs the contents of items.
LIST-LABEL Outputs data in a format suitable for producing labels.
LIST.ITEM Synonym for LIST-ITEM
LIST.LABEL Synonym for LIST-LABEL
LISTF4 List files in an acount in four columns
LPTR Direct report to a printer
LT Less than
MARGIN Define width of left margin
MATCH Synonym for LIKE
MATCHES Synonym for LIKE
MATCHING Synonym for LIKE
MAX Find maximum value of a field
MIN Find minimum value of a field
MULTI.VALUE Treat a field as multi-valued
MULTIVALUE Synonym for MULTI.VALUE
NE Not equal
NI-SUPP Suppress display of record count
NI.SUP Synonym for NI-SUPP
NO Test for a null field
NO-INDEX No index to be used for query.
NO.INDEX Synonym for NO-INDEX
NO.NULLS Suppress null fields in MIN and AVG calculations
NO.PAGE Synonym for NOPAGE
NO.SPLIT Ensure that, where possible, all of a record fits on a page
NOPAGE Suppress end of page prompt
NOT Synonym for NE
NOT.MATCHING Synonym for UNLIKE
OF Throwaway
ONLY Synony for ID.ONLY
OR Logical OR
PAGE Throwaway
PCT Synonym for PERCENT
PERCENT Report percentages
PERCENTAGE Synonym for PERCENT
PG Throwaway
PRINT Throwaway
REFORMAT Generates a formatted report of records and fields to a file or tape.
REQUIRE-INDEX An index must be used to process this query
REQUIRE-SELECT Only process query with an active select list
REQUIRE.INDEX Synonym for REQUIRE-INDEX
REQUIRE.SELECT Synonym for REQUIRE-SELECT
RETRIEVE Used with compiled jQL - see JQLCOMPILE
S-DUMP Outputs the sorted contents of items.
SAID Soundex matching
SAMPLE Select a specific number of records
SAMPLED Select only a sample of records
SAMPLING Synonym for SAMPLE
SAVING Save field value in place of Item ID
SDUMP Outputs the entire contents of items in sorted order
SELECT Generates a list of record keys or specified fields based on the criteria specified.
SELECT-ONLY Synonym for REQUIRE-SELECT
SELECT.ONLY Synonym for REQUIRE-SELECT
SINGLE.VALUE Treat a field as single-valued
SINGLEVALUED Synonym for SINGLE.VALUE
SORT Generates a sorted formatted report of records and fields from a specified file.
SORT4 Sort the Item IDs of a file in four columns
SORT-ITEM Sort items and display in their internal format
SORT-LABEL Outputs data in a format suitable for producing labels.
SORT.ITEM Synonym for SORT-ITEM
SORT.LABEL Synonym for SORT-LABEL
SPOKEN Synonym for SAID
SREFORMAT Generates a sorted formatted report of records and fields to a file or tape.
SSELECT Generates an sorted list of record keys or fields based on the criteria specified.
ST-DUMP Sorted T-DUMP
STAT File statistics
SUBVALUE
SUM Sum a specified field
SUPP Synonym for HDR-SUPP
T-DUMP Dump records to tape device
T-LOAD Load records from a tape device
T.DUMP Synonym for T-DUMP
T.LOAD Synonym for T-LOAD
TAPE Direct output of REFORMAT or SREFORMAT commands to tape
THAN Throwaway
THE Throwaway
TO Designate a select list to write to
TOTAL Report a total of a specified field
TRANSPORT Display the last value in a set of records
UNIQUE Use with SAVING to prevent duplicates
UNLIKE The inverse of LIKE
USING Specify an alternate dictionary to use
VERT Create a report in vertical format
VERTICALLY Synonym for VERT
WHEN Specify multi-value selection criteria
WITH Specify record selection criteria
WITHEACH Synonym for EACH
WITHIN Retrieve one record and its sub-records
WITHOUT Synonym for WITH NO
WITHOUTEACH The inverse of EACH
~ Synonym for SAID

Back to jQL