CLEANUP EXTRACT

Use CLEANUP EXTRACT to delete run history for the specified Extract group. The cleanup keeps the last run record intact so that Extract can resume processing from where it left off. Before using this command, stop Extract by issuing the STOP EXTRACT command.

Syntax

CLEANUP EXTRACT group_name [, SAVE count]

group_name

The name of an Extract group or a wildcard (*) to specify multiple groups. For example, T* cleans up all Extract groups whose names start with T.

SAVE count

Excludes the specified number of the most recent records from the cleanup.

Examples

Example 1   

The following deletes all but the last record.

CLEANUP EXTRACT exte

Example 2   

The following deletes all but the most recent five records.

CLEANUP EXTRACT *, SAVE 5