5-68 Command Reference
QUERY Purpose Searches the lookup file to find a specified record.
Syntax QUERY
buffer-field1
,
comparison
,
buffer-field2
[
,
[
invalid label
] [
, valid label
] ]
Process The QUERY command searches the lookup file to find a record containing a
specific value.
NOTE: If multiple records contain the value, the command reads the first record fitting the
criteria.
Buffer-field1
specifies the buffer to search and can be one of the following:
Buffer-field1
Description
Logical Field Name (LU1) Lookup Buffer Field
Comparison
defines the type of query and can be one of the following:
Comparison
Description
EQ Contents of
buffer-field1
is equal
to the contents of
buffer-field2
LT Contents of
buffer-field1
is less
than the contents of
buffer-field2
LE Contents of
buffer-field1
is less
than or equal to the contents of
buffer-field2
GT Contents of
buffer-field1
is greater
than the contents of
buffer-field2
GE Contents of
buffer-field1
is greater
than or equal to the contents of
buffer-field2
Buffer-field2
specifies the buffer holding the value to search on and can be one of
the following:
Buffer-field2
Description
INPUT Input Buffer
Logical Field Name
(TEMP1)
Temporary Buffer
Field
Logical Field Name (LU1) Lookup Buffer Field
Logical Field Name (PR1) Printer Buffer Field
Logical Field Name
(Field1) [Index]
Array Buffer Field
String
ASCII string delimited
by double quotes
Must be one
character long
Number Number prefixed by a
number sign (#)
If the query is successful and finds the record, the pointer is set to that record.