15.10 - PeriodsV[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

DatabaseName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

Dbase.DatabaseName

Table_Name

VARCHAR(128)

UNICODE

NOT NULL

X(128)

TVM.TVMName

Period_Name

VARCHAR(128)

UNICODE

NOT NULL

X(128)

TVFields.FieldName

Fid

SMALLINT

NOT NULL

---,--9

TVFields.FieldId

Tid

BYTE(6)

NOT NULL

X(12)

TVFields.TableId

DBid

BYTE(4)

NOT NULL

X(8)

TVFields.DatabaseId

START_COLUMN_NAME

VARCHAR(128)

UNICODE

X(128)

TVFields.FieldName

END_COLUMN_NAME

VARCHAR(128)

UNICODE

X(128)

TVFields.FieldName

For information about non temporal period columns that are derived from the physical DateTime columns that store the beginning and ending bound values of the derived periods, see ANSI Temporal Table Support.

START_COLUMN_NAME

The START_COLUMN_NAME column is the name of the column that stores the start column name of the valid-time derived period column, system-time derived period column, or nontemporal derived period column.

END_COLUMN_NAME

The END_COLUMN_NAME is the name of the column that stores the end column name of the valid-time derived period column, system-time derived period column, or nontemporal derived period column.

Suppose you have the following table definition:

CREATE SET TABLE TEST.employee ,NO FALLBACK ,
   NO BEFORE JOURNAL,
   NO AFTER JOURNAL,
   CHECKSUM = DEFAULT,
   DEFAULT MERGEBLOCKRATIO
   (
   eid INTEGER,
   jobdurstart DATE FORMAT 'YY/MM/DD' NOT NULL,
   jobdurend DATE FORMAT 'YY/MM/DD' NOT NULL,
   PERIOD FOR jobdur (jobdurstart, jobdurend),
   ename CHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX ( eid );

The following statement entered in BTEQ retrieves rows from the PeriodsV[X] view for the employee table created:

BTEQ -- Enter your SQL request or BTEQ command:
.SET FOLDLINE ON
.SET SIDETITLES ON
SELECT * FROM DBC.PeriodsVX WHERE table_Name = 'employee';
 
 *** Query completed. One row found. 8 columns returned.
 *** Total elapsed time was 2 seconds.
 
   DatabaseName test
    Table_Name employee
   Period_Name jobdur
       Fid  1,028
       Tid 00008D090000
       DBid 0000FA03
START_COLUMN_NAME jobdurstart
 END_COLUMN_NAME jobdurend