Version 7.4.4
 —  Utilities  —

DELETE: Delete File

The DELETE function deletes an Adabas file from the database.

graphics/util_adadbs_delete.png

When an Adabas file is deleted from the database, all logical extents assigned to the file are deallocated. The released space may be used for a new file or for a new extent of an existing file.

The file to be deleted may not be coupled. If an Adabas expanded file is specified, the complete expanded file (the anchor and all component files) is deleted.

When the DELETE function completes successfully, any locks previously set with the operator commands LOCKU or LOCKF are reset.

This document covers the following topics:


Essential Parameter

FILE: File to Be Deleted

FILE specifies the number of the Adabas file to be deleted. An Adabas system file may be specified only if ADADBS DELETE is the only Adabas user; deleting a system file automatically causes Adabas to terminate when finished. Adabas system files are checkpoint, security, triggers, and any other files loaded with the ADALOD utility's SYSFILE option. To delete an Adabas expanded file, specify the file number (also the anchor file).

Top of page

Optional Parameters

KEEPFDT: Retain the Field Definition Table

The KEEPFDT parameter, if specified, instructs ADADBS DELETE to keep the deleted file's field definition table (FDT) for later use by ADACMP. If this parameter is specified, a file with the same number as the one now being deleted can only be later loaded if either the new file's FDT is the same as that of the deleted file, or the load operation specifies the IGNFDT parameter to accept the new file's FDT.

NOUSERABEND: Termination Without Abend

When an error is encountered while the function is running, the utility prints an error message and terminates with user abend 34 (with a dump) or user abend 35 (without a dump).

If NOUSERABEND is specified, the utility will not abend after printing the error message. Instead, the message "utility TERMINATED DUE TO ERROR CONDITION" is displayed and the utility terminates with condition code 20.

PASSWORD: File Password

PASSWORD specifies the password of the file to be deleted. This parameter is required if the file is password-protected.

TEST: Test Syntax

The TEST parameter tests the operation syntax without actually performing the operation. Only the syntax of the specified parameters can be tested; not the validity of values and variables. See Syntax Checking with the TEST Parameter for more information on using the TEST parameter in ADADBS functions.

Top of page

Examples

File 6 is to be deleted.

ADADBS DELETE FILE=6

Password-protected file 10 is to be deleted. The field definition table is to be retained. File number 10 cannot be used again until another ADALOD LOAD command is issued with the IGNFDT option.

ADADBS DELETE
FILE=10,KEEPFDT,PASSWORD='FILE10'

Top of page