DICTIONARY IMPORT - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Imports object definitions from an export file created using the DICTIONARY EXPORT command.

This command validates imported objects against Teradata systems managed by Unity. It marks objects not matching underlying systems as invalid, and disallows dictionary deployment to the managed Unity Data Dictionary until the issues are resolved. The command also enables translation of Unity Data Dictionary names and Teradata system TDPIDs during the import process.

Syntax

DICTIONARY IMPORT [FROM | FILE=]import filename {SYSTEM tdpid1=new tdpid1 [,...tdpidN=new tdpidN]} {DICTIONARYNAME dictionary name 1=new dictionary name 1 [,...dictionary name N=new dictionary name N ]};

Parameters

DICTIONARYNAME
Specifies one or more source Unity Data Dictionary names and their target dictionary name values.
import filename
Specifies the name of the file to import from.
tdpid1 = new tdpid1
Specifies mapping of tdpids from files being imported.
<dictionary name 1 =new dictionary name 1
Specifies mapping of dictionary names from the file being imported.

Example

unityadmin>  DICTIONARY IMPORT FROM DICTIONARIES.TXT sys1 = sys1;