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

Working With KeySequenced Files in a UDB Pair
Working With Files
12–86 106160 Tandem Computers Incorporated
When deleting a record from a UDB pair, the FILE DEL verb operates as follows:
If the record is in neither file, the FILE DEL operation fails.
If the record is in the first file but not the second file, the record is deleted from the
first file (see Figure 12-23).
If the record is in the second file but not the first file, a delete-record is written to
the first file (see Figure 12-24). This marks the record in the second file as being
deleted; that is, the record in the second file is logically deleted.
If the record is in both files, a delete-record replaces the existing record in the first
file (see Figure 12-25). This marks the record in the second file as being deleted;
that is, the record in the second file is logically deleted.
Figure 12-23. Deleting a Record From a UDB Pair—Case 1
Before FILE DEL Verb.
B
C
G
File 1
1
File 2
2
File 1 has read and write access.
1 2
File 2 has read-only access.
After FILE DEL Verb.
B
C
G
File 1
1
File 2
FILE DEL KEY=A MDO=&rec.
Record A Deleted.
050
Legend
2
A