Previous Topic: HDELETE Control StatementNext Topic: LOAD Control Statement


Syntax

HDELETE detail-option

where:

detail-option

Specifies whether to delete or clear the records that contain existing history-definition data in the database.

Valid options are as follows:

DETAIL

Deletes the detail records.

This is the default.

ALL

Also deletes the basic history records.

HDELETE ALL

Deletes both basic and detail history records. The space utilized by the basic history records is marked as available for use but the blocks that contained those records are not returned to the database as free blocks. To reclaim these blocks, reorganize the database. This can be accomplished by doing either a RMODBASE COPY into a new database or a RMODBASE UNLOAD/RELOAD into a new database.