Historical Purge
Historical Purge (AM300) lets you purge selected asset records, past or current, from the Asset Management database. You must exercise caution when using this program.
Typically, you would use this program to reduce the size of the database files and is applied only to historical data. You could use it to purge current data such as test data.
You can purge one or more of these types of records for the company or company group and date range you select:
-
Adjustments
-
Transfers
-
Disposals
-
Reinstate
-
Transactions
-
Comments
-
URLs
-
Repairs
-
Conversion numbers
You can also archive the purged data to a set of comma-separated value (CSV) files. The program generates a separate CSV file for each database file affected by the purge selection and saves the files in this directory:
For UNIX:
$LAWDIR/ productline /work/ CSVdirectory where CSVdirectory is the same name as the file.
For Windows:
%LAWDIR%\ productline \work \CSVdirectory where CSVdirectory is the same name as the file.
For IBMi:
/LAWDIR/productline /work/ CSVdirectory where CSVdirectory is the same name as the file.
Archive files generated by AM300
Directory Name | File Name |
---|---|
$LAWDIR/ productline /work/AMASTBKADJ-OUT (UNIX) %LAWDIR%\ productline \work\AMASTBKADJ-OUT (Windows) /LAWDIR/productline /work/AMASTBKADJ-OUT |
AMASTBKADJ-OUT |
$LAWDIR/ productline /work/AMASTBKDSP-OUT (UNIX) %LAWDIR%\ productline \work\AMASTBKDSP-OUT (Windows) /LAWDIR/productline /work/AMASTBKDSP-OUT |
AMASTBKDSP-OUT |
$LAWDIR/ productline /work/AMBKTRANS-OUT (UNIX) %LAWDIR%\ productline \work\AMBKTRANS-OUT (Windows) /LAWDIR/productline /work/AMBKTRANS-OUT |
AMBKTRANS-OUT |
$LAWDIR/ productline /work/AMASTBKTRF-OUT (UNIX) %LAWDIR%\ productline \work\AMASTBKTRF-OUT (Windows) /LAWDIR/productline /work/AMASTBKTRF-OUT |
AMASTBKTRF-OUT |
$LAWDIR/ productline /work/AMASTITDSP-OUT (UNIX) %LAWDIR%\ productline \work\AMASTITDSP-OUT (Windows) /LAWDIR/productline /work/AMASTITDSP-OUT |
AMASTITDSP-OUT |
$LAWDIR/ productline /work/AMASTITADJ-OUT (UNIX) %LAWDIR%\ productline \work\AMASTITADJ-OUT (Windows) /LAWDIR/productline /work/AMASTITADJ-OUT |
AMASTITADJ-OUT |
$LAWDIR/ productline /work/AMTRANS-OUT (UNIX) %LAWDIR%\ productline \work\AMTRANS-OUT (Windows) /LAWDIR/productline /work/AMTRANS-OUT |
AMTRANS-OUT |
$LAWDIR/ productline /work/AMASSETADJ-OUT (UNIX) %LAWDIR%\ productline \work\AMASSETADJ-OUT (Windows) /LAWDIR/productline /work/AMASSETADJ-OUT |
AMASSETADJ-OUT |
$LAWDIR/ productline /work/AMASTBOOK-OUT (UNIX) %LAWDIR%\ productline \work\AMASTBOOK-OUT (Windows) /LAWDIR/productline /work/AMASTBOOK-OUT |
AMASTBOOK-OUT |
$LAWDIR/ productline /work/AMASSETDSP-OUT (UNIX) %LAWDIR%\ productline \work\AMASSETDSP-OUT (Windows) /LAWDIR/productline /work/AMASSETDSP-OUT |
AMASSETDSP-OUT |
$LAWDIR/ productline /work/AMASTITEM-OUT (UNIX) %LAWDIR%\ productline \work\AMASTITEM-OUT (Windows) /LAWDIR/productline /work/AMASTITEM-OUT |
AMASTITEM-OUT |
$LAWDIR/ productline /work/AMASTRPAIR-OUT (UNIX) %LAWDIR%\ productline \work\AMASTRPAIR-OUT (Windows) /LAWDIR/productline /work/AMASTRPAIR-OUT |
AMASTRPAIR-OUT |
$LAWDIR/ productline /work/AMASSET-OUT (UNIX) %LAWDIR%\ productline \work\AMASSET-OUT (Windows) /LAWDIR/productline /work/AMASSET-OUT |
AMASSET-OUT |
$LAWDIR/ productline /work/AMASSETTRF-OUT (UNIX) %LAWDIR%\ productline \work\AMASSETTRF-OUT (Windows) /LAWDIR/productline /work/AMASSETTRF-OUT |
AMASSETTRF-OUT |
$LAWDIR/ productline /work/AMASSETCMT-OUT (UNIX) %LAWDIR%\ productline \work\AMASSETCMT-OUT (Windows) /LAWDIR/productline /work/AMASSETCMT-OUT |
AMASSETCMT-OUT |
$LAWDIR/ productline /work/AMCNVASSET-OUT (UNIX) %LAWDIR%\ productline \work\AMCNVASSET-OUT (Windows) /LAWDIR/productline /work/AMCNVASSET-OUT |
AMCNVASSET-OUT |
$LAWDIR/ productline /work/AMASTITTRF-OUT (UNIX) %LAWDIR%\ productline \work\AMASTITTRF-OUT (Windows) /LAWDIR/productline /work/AMASTITTRF-OUT |
AMASTITTRF-OUT |
$LAWDIR/ productline /work/AMASSETURL-OUT (UNIX) %LAWDIR%\ productline \work\AMASSETURL-OUT (Windows) /LAWDIR/productline /work/AMASSETURL-OUT |
AMASSETURL-OUT |
To preserve the archived files, you must copy them to a separate directory. Otherwise, the archived files get overwritten each time you run the program again for the same types of records.