Import - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

Import

Use the command line interface to import information associated with a specified .mcf file onto a Teradata Database. If the requested information is not available in the file, then the switch is ignored.

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]
      [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 Teradata Database named test.

tset ‑c test ‑i cost.mcf ‑o ‑xapp

Import cost parameters from the cost.mcf file into a Teradata Database 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