NET/MASTER Network Control Language (NCL) Programmer's Guide
Working With KeySequenced Files in a UDB Pair
Working With Files
106160 Tandem Computers Incorporated 12–81
Getting a Record The FILE GET verb retrieves a record from a UDB pair. You can retrieve records from
mapped, unmapped, and delimited key-sequenced files in a UDB pair.
Note See the discussion on getting a record from an entry-sequenced file, earlier in this section, for information
on sequential retrieval. See the discussion on getting a record from a single key-sequenced file, earlier in
this section, for information on exact retrieval, generic retrieval, and how to specify the record key before
getting a record from a file.
The PATH operand of the FILE GET verb determines the key-sequenced file(s) in a
UDB pair from which a record is retrieved. You can retrieve a record from:
The first file in the UDB pair, by specifying PATH=ONE
The second file in the UDB pair, by specifying PATH=TWO
Either or both files in the UDB pair, by omitting the PATH operand or by
specifying PATH=ANY
Note If you specify PATH=ONE or PATH=TWO, you are attempting to retrieve a record from a single
key-sequenced file. See the discussion on getting a record from a single key-sequenced file, earlier in
this section, for details.
When retrieving records from either or both files in a UDB pair, the FILE GET verb
attempts to retrieve the record from the first file, then the second file (if present), as
follows:
If the record is in neither file, the FILE GET operation fails.
If the record is in the first file but not the second file, the record is retrieved from
the first file.
If the record is in the second file but not the first file, the record is retrieved from
the second file.
If the record is in both files, the record is retrieved from the first file.