15.10 - RCC_MediaV[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)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

EventNum

INTEGER

NOT NULL

--,---,---,--9

RCMedia.EventNumber

VolSerialId

CHAR(6) LATIN

NOT NULL

X(6)

RCMedia.VolSerialId

VolSequenceNum

SMALLINT

---,--9

RCMedia.VolSequenceNum

DupeDumpSet

CHAR(1) LATIN

NOT NULL

X(1)

RCMedia.DupeDumpSet

The following SELECT statement selects all rows and all columns from the RCC_Media view:

==> SELECT * FROM DBC.RCC_MediaV;

Result:

EventNum    ­VolSerialID   ­VolSequenceNum   ­DupeDumpSet
--------    -----------   --------------   -----------
      21    KAZ002              1          N
      76    RDB003              1          N
      66    RDB007              1          N
      19    KAZ002              1          N
      66    RDB008              2          N
      37    MET001              1          N
      77    RDB003              1          N
      .     .                   .          .
      .     .                   .          .