Valid fromsql Transform Functionality - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

The following table documents the valid targets for fromsql functionality.

Source Input Source Data Type of Routine Definition Target Data Type of Routine Definition Target Output
UDT UDT BYTEINT BYTEINT


SMALLINT


INTEGER


BIGINT


DECIMAL


NUMERIC


REAL


FLOAT


DOUBLE PRECISION


CHARACTER


VARCHAR


DATE

SMALLINT
INTEGER
BIGINT
DECIMAL


NUMERIC

REAL


FLOAT


DOUBLE PRECISION

BYTE BYTE


VARBYTE


BLOB

VARBYTE
BLOB
CHARACTER CHARACTER


VARCHAR
C

LOB


BYTEINT


SMALLINT

INTEGER


BIGINT


DECIMAL


NUMERIC


REAL


FLOAT


DOUBLE PRECISION


DATE


TIME


TIME WITH TIME ZONE


TIMESTAMP


TIMESTAMP WITH TIME ZONE

VARCHAR


CHARACTER

VARYING

CLOB CLOB


CHARACTER


VARCHAR

DATE DATE


BYTEINT


SMALLINT


INTEGER


BIGINT


DECIMAL


NUMERIC


REAL


FLOAT


DOUBLE PRECISION


CHARACTER


VARCHAR

TIME TIME


TIME WITH TIME ZONE

TIME WITH TIME ZONE
TIMESTAMP TIMESTAMP


TIMESTAMP WITH TIME ZONE

TIMESTAMP WITH TIME ZONE
INTERVAL YEAR INTERVAL YEAR

INTERVAL YEAR TO MONTH


INTERVAL MONTH

INTERVAL YEAR TO MONTH
INTERVAL MONTH
INTERVAL DAY INTERVAL DAY


INTERVAL DAY TO HOUR


INTERVAL DAY TO MINUTE


INTERVAL DAY TO SECOND


INTERVAL HOUR


INTERVAL HOUR TO MINUTE


INTERVAL HOUR TO SECOND


INTERVAL MINUTE


INTERVAL MINUTE TO SECOND


INTERVAL SECOND

INTERVAL DAY TO HOUR
INTERVAL DAY TO MINUTE
INTERVAL DAY TO SECOND
INTERVAL HOUR
INTERVAL HOUR TO MINUTE
INTERVAL HOUR TO SECOND
INTERVAL MINUTE
INTERVAL MINUTE TO SECOND
INTERVAL SECOND