Teradata data types can be categorized as follows.
1) Character data:
This is character data that can be fixed or variable length.
The data types can be CHAR, VARCHAR, CHAR VARYING, LONG
VARCHAR.
2) Arithmetic Numeric data:
This is numeric data that can have arithmetic operations
performed on it.
This numeric data is usually money or quantity values.
The data types can be DATE, DECIMAL, NUMERIC, BYTEINT,
SMALLINT, INTEGER, REAL, DOUBLE PRECISION, or FLOAT.
The arithmetic operations can be:
SUM(t1.c1), MAX(t1.c1), t1.c1 + t2.c1, etc.
3) Non-Arithmetic Numeric data:
This is numeric data that will not have arithmetic
operations performed on it.
This numeric data is usually code or id values, and usually,
is not money or quantity values.
The data types can be DATE, DECIMAL, NUMERIC, BYTEINT,
SMALLINT, INTEGER, REAL, DOUBLE PRECISION, or FLOAT.
4) Byte data:
This is bit oriented data, with hexadecimal orientation of
values.
This data type is not currently used in the EDW application
tables.
The data types can be BYTE, VARBYTE.
This data will not be covered as part of this NULL topic.
5) Graphic data:
This is Japanese Kanji oriented data, with a mixture of
single and multiple bytes representing the Japanese language.
This data type is not currently used in the EDW application
tables.
The data types can be GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC.
This data will not be covered as part of this NULL topic.
No comments:
Post a Comment