To generate a list of files and tables selectively by object type and criteria
unica_acclean -o <list file name> -w {flowchart | campaign | session | sessionfolder | campaignfolder} -s
criteria
[-r]
Example 1: list temp files and tables by campaign folder
unica_acclean -o "JanuaryCampaignsList.txt" -w campaignfolder -s "NAME='JanuaryCampaigns'" -r
This example generates a list of temporary files and tables associated with campaigns and flowcharts in the campaign folder named "JanuaryCampaigns" as well as all subfolders of "JanuaryCampaigns", and writes it to the file
JanuaryCampaignsList.txt.
Example 2: list temp files and tables by flowchart LASTRUNENDDATE
unica_acclean -o "LastRun_Dec312006_List.txt" -w flowchart -s "LASTRUNENDDATE < '31-Dec-06'"
This example generates a list of all temp files and tables with LASTRUNENDDATE earlier than December 31, 2006, in all flowcharts, and writes it to the file
LastRun_Dec312006_List.txt.
Make sure that any date criteria are specified in the correct date format for your database.
Copyright IBM Corporation 2015. All Rights Reserved.
