Use the command line interface to clean up or remove information previously imported onto the 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 database system 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 database system named test, as logged in the specified .undo file, are cleaned up.