有効なfromsqlデータ変換機能 - Advanced SQL Engine

有効なfromsqlデータ変換機能 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ定義言語詳細トピック

Product

Advanced SQL Engine

Teradata Database

Release Number

17.05

17.00

Published

2020年6月

ft:locale

ja-JP

ft:lastEdition

2021-03-30

dita:mapPath

ja-JP/jpx1556733107962.ditamap

dita:ditavalPath

ja-JP/jpx1556733107962.ditaval

dita:id

B035-1184

Product Category

Software

Teradata Vantage

以下の表で、fromsql機能に有効なターゲットを説明します。

ソースの入力値	ルーチン定義のソースデータ型	ルーチン定義のターゲットデータ型	ターゲットの出力
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	TIME  TIME WITH TIME ZONE
		TIMESTAMP	TIMESTAMP  TIMESTAMP WITH TIME ZONE
		TIMESTAMP WITH TIME ZONE	TIMESTAMP  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