Aster Data Types - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities
Aster Option Description
BYTEA Variable-length binary string
CHAR Fixed length character string. In Size type the size limit of the character string.
DATE A calendar date consisting of year/month/day
DOUBLE PRECISION Double-precision Floating-point number. There are no additional options.
INTEGER 32-bit binary integer. There are no additional options.
INTERVAL There are no additional options.
IP4 IP address
IP4Range Range of IP addresses
NUMERIC Numeric data such as integers, real numbers, and floating-point numbers. An Aster Database numeric must have a scale and precision to be exported, due to the different meanings of precision and scale in different systems. In Precision, type the total count of significant digits in the whole number, that is, the number of digits to both sides of the decimal point. In Scale, type the count of decimal digits in the fractional part, to the right of the decimal point. For example, the number 23.5141 has a precision of 6 and a scale of 4.
SMALLINT Signed two-byte integer. There are no additional options to enter.
TEXT Stores strings of any length. In Size type the limit of the text size.
TIME A time consisting of hour/minute/second/fractional second
TIME WITH TIME ZONE A TIME with a displacement from UTC
TIMESTAMP A timestamp consisting of year/month/day/hour/minute/second/fractional second
TIMESTAMP WITH TIME ZONE A TIMESTAMP with a displacement from UTC
UUID Stores Universally Unique Identifiers (UUID) as defined by RFC 4122, ISO/IEC 9834-8:2005, and related standards.
VARBIT Variable length binary string
VARCHAR Variable length character string