15.10 - Database_Default_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)

Database

DBC

 

View Column

Data Type

Format

Source Table.Column

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

Journal_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 following SELECT statement selects the information on each database accessible by the requesting user for which a default journal table is defined:

    ==> SELECT * FROM DBC.Database_Default_JournalsV;

    Result:

    DatabaseName  Journal_DB  JournalName
    ------------  ----------  ------------
    DtBs1         DtBs1       DtBs1Jrnl
    DtBs2         DtBs2       DtBs2Jrnl
    DtBs3         DtBs1       DtBs1Jrnl