Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. Repositories
  4. XML Data Source
  5. Tests for XML Data Sources
  6. Connections
  7. Expressions
  8. Table Pairs
  9. Tests for Table Pairs
  10. Single-Table Constraints
  11. Tests for Single-Table Constraints
  12. Examples of Tests from Spreadsheets
  13. SQL Views
  14. Lookup Views
  15. Join Views
  16. Aggregate Views
  17. Business Intelligence and Reporting Tools Reports
  18. Dashboards
  19. DVOCmd Command Line Program
  20. Troubleshooting
  21. Appendix A: Datatype Reference
  22. Appendix B: Reporting Views
  23. Appendix C: Metadata Import Syntax
  24. Appendix D: Jasper Reports
  25. Appendix E: Glossary

Data Validation Option User Guide

Data Validation Option User Guide

PurgeRuns

PurgeRuns

Purges test runs from the Data Validation Option repository. You can purge deleted test runs or purge test runs by date. When you purge test runs by date, you can purge all test runs that occur on or after a specified date, before a specified date, or between two dates. You can run this command on Windows.
The
PurgeRuns
command uses the following syntax:
DVOCmd PurgeRuns [--confdir conf_dir] [--username User name] [--password Password] [--ePassword Password Environment Variable] [--namespace Namespace] [--deleted] [--fromDate from_date] [--toDate to_date]
If you configure Informatica authentication for the Data Validation Option schema, enter --username and --password.
The following table describes
PurgeRuns
options and arguments:
Option
Argument
Description
--confdir
conf_dir
The user configuration directory. Specify the configuration directory if you have multiple Data Validation Option repositories on a client machine. If you have one Data Validation Option repository on a client machine and have not changed the configuration directory, you do not need to specify this option.
Because Windows directories often contain spaces, you must enclose the file path in quotes.
--username
User name
Informatica domain user name for the domain to which you configured Informatica authentication.
Required if you configure Informatica authentication.
--password
Password
Password for the Informatica user name.
Required if you configure Informatica authentication.
If you set the
password
option, then do not set the
ePassword
option.
--ePassword
Password Environment Variable
Encrypted form of the password of the Informatica user name.
Use the DVOCmd EncryptPassword command to encrypt the password. Set an environment variable to the encrypted password and use the variable in the
ePassword
option. The command replaces the environment variable with the encrypted password and then decrypts the password.
If you set the
ePassword
option, then do not set the
password
option. If the command contains both the
password
and
ePassword
options, then the Data Validation Option uses the
ePassword
and ignores the
password.
--namespace
Namespace
Namespace of the LDAP domain.
Required if you configure Informatica Authentication with LDAP domain.
--deleted
-
Purges deleted test runs.
--fromDate
from_date
Purges test runs that occur on or after this date.
--toDate
to_date
Purges test runs that occur before this date.