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

Working With Single Key-Sequenced Files
Working With Files
106160 Tandem Computers Incorporated 12–69
Generic Deletion
Generic deletion assumes that the value of the current key (set by the KEY operand) is
a partial key. A partial key is a truncated version of a full key. In a partial key only
some of the leading characters are supplied. Deletion by partial key is normally used
when you want to delete many records. Table 12-8 lists the options you can use to
specify the method of generic deletion; Figure 12-17 illustrates generic deletion.
Table 12-6. Generic Deletion Options
Option Meaning
KEQALL Deletes the specified record and all following records that have keys matching the
partial key provided.
KGEALL Deletes the specified record and all following records that have keys greater than
or equal to the partial key provided.
Figure 12-17. Generic 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"
FILE DEL OPT=KEQALL
041
Generic Deletion
Deletes 4 Records