Use the command line interface to clean up or remove information previously imported onto a Teradata Database. If the requested information is not available to be cleaned up, then the switch is ignored.
-
Use the following command syntax to clean up imported information:
tset [-icf <commandfile>]| [[-c|-l] <DSN_or_tdpid>\<username>\<password> [-am <Authentication Mechanism>\<Authentication Parameter>] [-scs <Session characterset>] [-u <undofile>] [-d -s -r -p -o -g -w -e -q -m] [-xapp]]
The following are examples of how to clean up imported information from the command line. Type:
tset -c test -u prod.31-Jul-04.22.33.12.undo
The information that was imported into a Teradata Database named test, as logged in the specific .undo file, is cleaned up. Type:
tset -c test\dbc -u prod.31-Jul-04.22.33.12.undo -q
The DBQL XML Plans that were imported into a Teradata Database named test, as logged in the specified .undo file, are cleaned up.