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=]importfilename {SYSTEM tdpid1=newtdpid1 [,...tdpidN=newtdpidN]} {DICTIONARYNAME dictionaryname1=newdictionaryname1 [,...dictionarynameN=newdictionarynameN ]};Parameters
- importfilename
- Specifies the name of the file to import from.
- tdpid1=newtdpid1
- Specifies mapping of tdpids from files being imported.
- dictionaryname1=newdictionaryname1
- Specifies mapping of dictionary names from the file being imported.
Example
unityadmin> DICTIONARY IMPORT FROM dictionaries.txt SYSTEM devsys1=prodsys1, devSys2=prodsys2;