|
To create a procedure for automatic data maintenance:
| 1. | In the USoft BenchMark toolbox, double-click Procedures in the Test Database list. |
| 3. | Type a name for the procedure (for example, REBUILD) in the Procedure Name field. |
| 4. | Put the cursor in the lower info box, and define the various steps that you want your cleanup procedure to take as shown in the following table. |
USoft BenchMark Action
|
Description
|
top-test-drop-tables()
|
This action completely drops your application tables from the database.
|
top-test-create-tables()
|
This action rebuilds your application tables on the basis of the definitions in the repository.
|
top-test-clear-tables()
|
This action only removes the contents of your application tables.
|
top-test-export()
|
This action exports your application data to a TDF file in the working directory.
|
top-test-Import()
|
This action imports your application data from a TDF file in the working directory.
|
top-test-constraint-violation-
report()
|
This action produces a report listing any constraints that are violated.
|
top-test-relationship-violation-report()
|
This action produces a report listing data violating referential integrity in a relationship; namely minimum number of children and foreign key.
|
| The filename that is to be used for exporting and/or importing can be entered in the Parameter field. The Position, Application Status, Record Status, Execute Procedure fields can be left empty. The Target field MUST contain "*topCase". |
| 5. | Fill in the other fields as required. |
| 6. | In the USoft BenchMark toolbox, click the Save button. |
|
