To purge records based on days

1. Open a command window and navigate to the directory where you downloaded the scripts.

2. Do one of the following:

   • For Oracle and DB2 databases, enter the following command:

     purge_by_days user password database days

   • For Sybase and SQL Server databases, enter the following command:

     purge_by_days user password server database days

   Where days is the number of days to retain. For example, if you specify 4 days, then any records older than 4 days are purged.