Previous Topic: DISPLAY Command—Display Space InformationNext Topic: RELEASE Command—Display Database Creation Time


PURGE Command—Purge Data from the Database

The PURGE command purges specified data from the database.

The command has the following syntax. All parameters are optional but position dependent. If more than one parameter is present, the command evaluates them using AND operations to determine which records are purged.

PURGE,sysid,applicationid,startdate,starttime,enddate,endtime
sysid

Specifies a CAICCI ID. Records that are associated with this CAICCI are purged.

applicationid

Specifies an application ID. Records that are associated with this application are purged.

startdate and starttime

Specifies the beginning of a time interval over which records are purged.

startdate is in yyyyddd, where yyyy is the year and ddd is the day of the year (for example, 2006305).

starttime is in hh:mm:ss.

Default: 0

enddate and endtime

Specifies the end of a time interval over which records are purged.

enddate is in yyyyddd, where yyyy is the year and ddd is the day of the year (for example, 2006305).

endtime is in hh:mm:ss.

Default: 999999

Example: Purge Specific Records

The following command purges the records from November 1, 2004 at 8 a.m. through November 30, 2004 at midnight that is associated with the CAICCI identified as A01IENF and the CA‑TSS application:

F CCILGR,PURGE,A01IENF,CA‑TSS,2004305,08:00:00,2004334,24:00:00

Example: Purge All Records

The following command purges all records from the database:

F CCILGR,PURGE,,,0