Undoing Imported Information - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
gnf1527114222337.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities
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.