15.10 - JournalsV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Schema

DBC

 

View Column

Data Type

Format

Source Table.Column

Tables_DB

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

TableName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName (NUSI)

Journals_DB

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

JournalName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName (NUSI)

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.Owners
  • DBC.RoleGrants
  • DBC.Roles
  • The statement on the following screen selects information from the Journals view for the table named PriceA:

    ==> SELECT TableName,Tables_DB,Journals_DB,JournalName
           FROM DBC.JournalsV WHERE Tablename = 'PriceA' ;

    Result:

    TableName  Tables_DB  ¬≠Journals_DB  ¬≠JournalName
    ---------  ---------  -----------  ------------
    PriceA     Acctng     Acctng       JNLA
    .              .        .            .
    .              .        .            .
    .              .        .            .