Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> Supported Keywords and Features> Teradata Keywords and Features

Teradata Keywords and Features

Table 1 describes the Teradata keywords and features supported by DSC.

The Version column lists the earliest version that supports a keyword or feature.

The Remarks column describes how to configure the migration of a keyword or feature.

**Table 1** Teradata keywords and features supported by DSC
Section	Object and Keyword/Feature		Version	Remarks
Schema Objects	Table	CREATE TABLE	V100R003C00	Configured by setting session_mode
		CHARACTER SET and CASESPECIFIC	18.1.0	Configured by setting tdMigrateCharsetCase
		VOLATILE	V100R003C00	Configured by setting volatile and session_mode
		SET	V100R003C00	-
		MULTISET	V100R003C00	-
		TITLE	V100R003C00	-
		INDEX	V100R003C00	-
		CONSTRAINT	V100R003C00	-
		COLUMN STORE	V100R003C00	Configured by setting rowstoreToColumnstore
		PARTITION	18.0.0	-
		ANALYZE	V100R003C30	-
		Data Types	6.5.1, 18.2.0	-
		Support for Less Columns Specified	18.0.0	-
Schema Objects	Index		V100R003C00	-
Schema Objects	View	REPLACE VIEW	V100R003C00	-
		CHECK OPTION	V100R003C00	-
		VIEW WITH RECURSIVE	V100R003C00	-
		VIEW WITH ACCESS LOCK	V100R003C00	-
Schema Objects	COLLECT STATISTICS		V100R003C00	-
Schema Objects	ACCESS LOCK		V100R003C00	Configured by setting tdMigrateLOCKOption
Schema Objects	DBC.Columns		18.0.0	Configured by custom DB scripts
Schema Objects	DBC.TABLES		18.1.0	-
Schema Objects	DBC.INDICES		18.1.0	-
DML			V100R003C00	-
	SELECT
	UPDATE		V100R003C00	-
	DELETE		V100R003C00	-
	MERGE		V100R003C00	-
	NAMED		18.0.0	-
Query Migration Operators	QUALIFY		V100R003C00	Configured by setting rowstoreToColumnstore
	ALIAS		V100R003C00	Configured by setting tdMigrateALIAS
	FORMAT AND CAST		V100R003C00	-
	Short Keys Migration		V100R003C00	-
	Object names Starting With $		18.0.0	Configured by setting tdMigrateDollar
Query Optimization Operators	IN and NOT IN Conversion		V100R003C00	Configured by setting inToExists
System Functions and Operators	Analytical Functions		18.1.0	-
System Functions and Operators	Comparison and List Operators	1 2 3 4 5 6 7 8	V100R003C00	-
System Functions and Operators	Table Operators		18.0.0	-
Math Functions	** MOD NULLIFZERO ZEROIFNULL		V100R003C00	Configured by setting tdMigrateNULLIFZERO and tdMigrateZEROIFNULL (18.0.0)
String Functions	CHAR function CHARACTERS function INDEX STRREPLACE OREPLACE		V100R003C00	-
Date and Time Functions	DATE TIMESTAMP NEXT		V100R003C00 18.0.0 V100R003C00	-
Type Casting and Formatting	CHAR COLUMNS and COLUMN ALIAS Expressions INT DATE DAY to SECOND DECIMAL Time interval NULL Implicit type casting issues		V100R003C00	-

Parent topic: Supported Keywords and Features

Last Article: Overview

Next Article: Oracle Keywords and Features

Did this article solve your problem?

Thank you for your score！Your feedback would help us improve the website.

Products

Compute

Application

Dedicated Cloud

Storage

Management & Deployment

Migration

Network

Enterprise Intelligence

Video

Database

Edge Cloud Services

DevCloud

Security

Cloud Communications

Internet of Things

Solutions

Industry-Specific Solutions

General-Purpose Solutions

Security

DevOps

Enterprise Intelligence

Essential Platform

Big Data

Visual Cognition

Speech and Semantics

Support

Help Center

Customer Services

Developers

Console

语言 - Language

中国站 - 简体中文

中国站 - English

International - 简体中文

International - English

Help Center

Teradata Keywords and Features