Previous Topic: DISPLAY Command—Display Space Information

Next 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 to be purged.

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

Specifies a CAICCI ID. Records associated with this CAICCI will be purged.

applicationid

Specifies an application ID. Records associated with this application will be purged.

startdate and starttime

Specifies the beginning of a time interval over which records will be 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 will be 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