Importing Information - System Emulation Tool

Teradata® System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
log1544831946868.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities
Use the command line interface to import information associated with a specified .mcf file onto the database. If the requested information is not available in the file, then the switch is ignored.
  1. Use the following command syntax to perform an import:
    tset [-icf <commandfile>]|
         [[-c|-l] <DSN_or_tdpid>\<username>\<password>
          [-am <Authentication Mechanism>\<Authentication Parameter>]
          [-scs <Session characterset>]
          [-i <importfile>
        [-tardbql <targetDBQLName>]
          [-d -s -r -p -o -g -w -e -q -m]
          [lsr]
          [-xapp]]

    The following examples demonstrate ways to import from the command line.

    Syntax Example Description
    tset -l test\dbc\dbc -i prod.mcf Import all of the information available in the prod.mcf file onto a database system named test.
    tset -c test -i cost.mcf -o -xapp Import cost parameters from the cost.mcf file into a database system named test. The application remains open after the import is completed.
    tset -c prod\dbc -i <importfile> -tardbql dbqatxml -q Import DBQL XML plans available in the import file to the specified target DBQL database DBQATXML