16.10 - DICTIONARY LIST - 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

Purpose

Lists all dictionaries or dictionaries on a specified database.

Syntax

DICTIONARY LIST [ DATABASES <DictionaryName>];

Parameters

dictionary name
Lists if the specified dictionary exists.

Keywords

DATABASES
Keyword that precedes dictionary names. If provided, the database specified after the keyword is returned as part of the response.

Example

Lists all dictionaries. This example shows one deployed dictionary and two working dictionaries.

unityadmin> dictionary list;
---------------------------------------------
Dictionary Name : JasonDict1
Last Modified Time : 2015-03-17 14:11:23.
Last Deployed Time : 2015-03-17 14:12:32.
Status : No scan in progress
---------------------------------------------
Dictionary Name : JasonDict2
Last Modified Time : 2015-03-17 14:13:21.
Last Deployed Time : Currently not deployed
Status : No scan in progress
---------------------------------------------
Dictionary Name : JasonDict3
Last Modified Time : 2015-03-17 14:15:04.
Last Deployed Time : Currently not deployed
Status : No scan in progress
Lists all dictionaries on a database. This example shows no database exists.
unityadmin> dictionary list databases jasondict1;
---------------------------------------------
Dictionary Name : JasonDict1
Last Modified Time : 2015-03-17 14:11:23.
Last Deployed Time : 2015-03-17 14:12:32.
Status : No scan in progress
Associated Databases:
Database: jason
Systems: jasonu2, jasonu4