Attribute Function Overview
Attribute functions return descriptive information about their operand. Except for the DEFAULT function, the operand need not be a column reference; it can be a general expression that is not evaluated mathematically.
When an attribute function is used in a request, the response returns one row for every data row that meets the search condition.
Some of these functions are extensions to ANSI SQL.
For a list of data type attributes, see “Data Type Phrases” in SQL Data Types and Literals.
Each attribute function is described individually in the following topics.
ANSI Equivalence of Teradata Attribute Functions
Several of the Teradata attribute functions are extensions to the ANSI SQL:2011 standard.
To maintain ANSI compatibility, use the ANSI equivalent functions instead of Teradata attribute functions, when available.
|
Change this Teradata function … |
To this ANSI function in new applications … |
|
CHARACTERS |
CHARACTER_LENGTH |
|
MCHARACTERS† |
|
|
† This function is no longer documented because its use is deprecated and it will no longer be supported after support for KANJI1 is dropped. |
|
The following Teradata functions have no ANSI equivalents: