Constant Class Property Descriptions - Teradata Meta Data Services

Constant Class Property Descriptions

Table 55: Constant Class Property Descriptions 

Property Name	Description
ConstantType	The type of the constant. Valid values are:
	ACCOUNT * ACTIVITY_COUNT ALL ANSIDATE ASCII AUTOTEMP AVERAGE* BIGINT BINARY CHARSET_COLL CHAR_SET_GRAPHIC CURRDATE * CURRENT_ROLE CURRENT_USER CURRTIME * CURRTIMESTAMP * DATABASE * DATE * DECIMAL DEFAULT DENSE DQUOTESTR EBCDIC FLOAT HEXSTR HIGH HOST INTEGER INTEGERDATE JIS_COLL	KANJI KANJISJIS LATIN1 LOCAL LOW MANUAL MEDIUM MULTINATIONAL NAME NEVER NULL OFF PARMNAME PREPARE_COUNT PROFILE * ROLE * SESSION * SOURCE_TIME_ZONE SQLCODE SQLSTATE SQUOTESTR STAR TEMPORAL_DATE TEMPORAL_TIMESTAMP TIME * UNICODE UNKNOWN UNTIL_CHANGED USER * ZONE*
ConstantValue	The value of the constant

Values marked with * in the table are converted from constants to functions before being stored in the MDS repository, and become part of function class “BI” (built-in). Date, Time, Timestamp and Interval literals are stored as constant type SQUOTESTR (single quoted string).

The following notes apply to constants referenced by a view column and functions referenced by view columns, stored procedures, macros, and so on:

If a constant is referenced as a standalone value or in combination with other constants in an expression, the constant or expression is stored in the repository and associated with the view column.

For example, when a view column references the standalone constant 10, or the expression of constants 10 + 20, then 10 or 10 + 20 is stored in the repository and associated with the view column.

When a constant is used as a function parameter, such as in the function log(5), the constant and function are stored in the repository and associated with the view column.

If a view column references a table column in combination with another table column, both columns are stored in the repository and associated with the view column.

For example if a view column references table columns c1 + c2, both c1 and c2 are stored in the repository and associated with the view column.

Because operators are not stored in the repository, it is not possible to determine if a view column has two associated table columns because of an arithmetic operator such as (+) or a binary operator such as OR.