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

Working With Single Key-Sequenced Files
Working With Files
12–68 106160 Tandem Computers Incorporated
Deleting a Record The FILE DEL verb deletes one or more records in key-sequenced file. You can delete
records from mapped, unmapped, and delimited key-sequenced files. When you
delete a record, you must specify the value of the record key, using the KEY operand,
either before deleting the record, using the FILE SET verb, or when you delete the
record, using the FILE DEL verb.
You can use two methods to delete records from a UDB: exact deletion by a specific
key or deletion by a generic key.
Exact Deletion
Exact deletion by an exact key value is the default. Deletion by a specific key deletes
only the record that matches the specified key. Figure 12-16 illustrates exact deletion.
Figure 12-16. Exact Deletion
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 OPEN ID=MYFILE
FILE SET KEY="JOHNSON, E.E."
FILE DEL
040
Exact Deletion
Deletes 1 Record