16.00 - Smart Load Data Types for Aster Tables - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K

The following data types are supported in the Smart Load Wizard for Aster tables.

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