850-FILTER-SUBRNG-<Index>
Name
850-FILTER-SUBRNG-<Index>
Description
Makes the database call.
Using the API in a Program
The database routines perform an equal condition on all DB
Index fields up to the subrange field designated in
the WS-DB-SUB-RNG
. It performs a
"where greater-than and less-than" condition on this index
field.
Input Values
| Field | Description |
|---|---|
|
<Index> |
You must specify the index in the FIND statement. |
Record retrieval variables (also known as DB
fields)
|
Define the beginning and ending values of the last key
by moving the appropriate values to the record retrieval fields named DB-
<KeyFieldName> and DBRNG-
<KeyFieldName>.
|
WS-DB-BEG-RNG
|
Move the symbolic constant <IndexName>-<IndexFieldName> to the field WS-DB-BEG-RNG in order to tell the interface which key is the last significant one defining the range. The symbolic constant is numerically equivalent to the position of the named field in the Index. |
WS-DB-SUB-RNG
|
Move the symbolic constant <IndexName>-<IndexFieldName> to the field WS-DB-SUB-RNG in order to tell the interface which key is the last significant one defining the range. The symbolic constant is numerically equivalent to the position of the named field in the index. |
| Filter value parameter | Set this parameter using a method described in Setting the Filter Parameter Value, and create the filter using the routine described in 890-CREATE-FILTER. |
Return Values
| Field | Description |
|---|---|
| <FileName>-SW | The Find routines set the <FileName>-SW switch to indicate the outcome of the read. |
|
<FileName>-FOUND |
Each routine sets the logical value <FileName>-NOTFOUND or <FileName>-FOUND based on the outcome of the read process. |
Programming Example
See the programming example for 850-FILTER-MIDSUB-<Index>.