NET/MASTER Network Control Language (NCL) Programmer's Guide

Working With Single Key-Sequenced Files
Working With Files
106160 Tandem Computers Incorporated 12–61
2. Retrieve the record that exactly matches the current key by using a FILE GET verb
that either specifies OPT=KEX or omits the OPT operand, for example:
FILE GET OPT=KEX ARGS
The second option requires one FILE GET verb to retrieve a record. The FILE GET
verb both sets the current record key and retrieves the record, for example:
FILE GET KEY=ABCDEF ARGS
Figure 12-14 illustrates exact retrieval.
Figure 12-14. Exact Retrieval From a Key-Sequenced File
ADAMS, E.W.
ANDERSON, K.A.
BOND, A.E.
BROWN, E.R.
BROWN, R.B.
JACKSON, P.Q.
JOHNSON, A.E.
JOHNSON, E.E.
JOHNSON, P.T.
JOHNSON, X.A.
SMITH, D.P.
STEVENSON, E.R.
WILLIAMS, J.J.
FILE GET KEY="JOHNSON, E.E." OPT=KEX ARGS
038
Exact Retrieval
Gets 1 Record
The FILE GET verb finds the first record in the key-sequenced file that matches the
JOHNSON, E.E. key value. In this example, the FILE GET verb retrieves one record.