DICTIONARY EXPORT - 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

Exports a set of Data Dictionaries or a set of Teradata Databases to a file containing all object details for table objects managed by Unity.

Syntax

DICTIONARY EXPORT <dictionaryname1>[…, <dictionarynameN>] FILE[=] <exportfilename> ;

Parameters

DATABASES
Specifies a database-based export that requires the name of one or more databases to export. Unity exports all table objects in the databases you list.
dictionaryname
Name of a Unity Data Dictionary that exists in the Unity repository.
exportfilename
Name of the file, including file path, to which Unity exports the table objects.
FILE
Specifies the file and location in which to save table objects and Unity Data Dictionary information.

Usage Considerations

Use a comma to separate multiple database or dictionary names in a list. You must specify a Unity Data Dictionary or Teradata Database from which table objects are exported and also the file location and name where you want the exported table objects stored.

Example

unityadmin>  DICTIONARY EXPORT luna FILE=solarsystem.txt;