Auto Compare & Set Delete
Previous Topic  Next Topic 

The Compare & Set Delete can be executed in a batch or command file.  The command is:


AutoCompareForDelete=CommandFile.txt


Where the command file is an exiting text file that has the following definitions:


       SQLScriptName=Name of DMS SQL Script


The DMS SQL script must already be defined.


An example of a complete auto execute command line would be:


"UserIniFolder=C:\Dynafact\Production\DMS\User\" "AutoUserName=DMS" "DatabaseName=DMSProduction" " AutoCompareForDelete =C:\Dynafact\CompareForDelete.txt"  AutoLogOut


The above command line would:


  1. Specify the location of the DMS user INI folder.
  2. Log on using the username DMS.
  3. Specify that the database name is DMSProduction
  4. Run the AutoCompareForDelete using the command file CompareForDelete.txt
  5. Log off from DMS.


Note that any command line parameter that has spaces needs to be surrounded in double quotation marks.


The command file has one parameter and that is SQLScriptName.  Command files do not use quotation marks around parameters.  An example of the parameter is given below where the SQL scrip to run is Compare To Host:


SQLScriptName=Compare To Host