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 |