15.10 - CostProfileTypes_v - 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

ProfileTypeName

CHAR(30) LATIN

NOT CASESPECIFIC

NOT NULL

X(30)

CostProfileTypes.ProfileTypeName (USI)

ProfileTypeDesc

VARCHAR(2048) LATIN

NOT CASESPECIFIC

X(2048)

CostProfileTypes.ProfileTypeDesc

The following example shows how to list the defined profile types. Only one type is defined.

==> SELECT ProfileTypeName (TITLE 'Type Name', FORMAT 'X(8)'),
    ProfileTypeDesc (TITLE 'Description', FORMAT 'X(80)') 
       FROM DBC.CostProfileTypes_v;

Result:

Type Name Description
--------- ----------------------------------------------------------
Legacy   Traditional (V2R6 & prior releases) cost values for legacy