850-FIND-BEGRNG-<Index>

Name

850-FIND-BEGRNG-<Index>

Description

When you need to process a range of data without interruption, 850-FIND-BEGRNG-<Index> retrieves the first database record in the range.

Using the API in a Program

850-FIND-BEGRNG-<Index> must be paired with 860-FIND-NXTRNG-<Index> .

The database routines perform an equal condition on all DB fields that have an assigned value—that is, all columns up to, and including, the field moved to the WS-DB-BEG-RNG .

Input Values

Field Description

<Index>

You must specify the index in the FIND statement.

Record retrieval variables (also known as DB fields) Fill in only the DB fields that define the appropriate range; leave empty those DB fields that do not define the range.

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.

Return Values

Field Description
<FileName>-SW The Find routines set the <FileName>-SW switch to indicate the outcome of the read.

<FileName>-NOTFOUND

<FileName>-FOUND

Each routine sets the logical value <FileName>-NOTFOUND or <FileName>-FOUND based on the outcome of the read process.

Programming Example

See Programming Examples.