bdfd1m21Database Administration

ADD/DEL-Type Files with Fixed-Length Items

ADD/DEL-type files with fixed-length items have 2 NAB pointers. One NAB value identifies the start of the active items, the other identifies the end. Figure 72 shows an example of the DBDEF statements to describe this type of file.

Figure 72. ADD/DEL-Type File with Fixed-Length Items (CBV=1)


Notes:

  1. This figure shows a file ('YQ'), which contains 2 fields (yyyyADP, and yyyyDEP).

  2. yyyyADP contains an ADD pointer, which defines where the next item should be added.

  3. yyyyDEP contains a DEL pointer, which defines the next item to be deleted.

  4. The items are fixed-length, and contain a reference to another file ('YR').