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;