Supported Keywords and Features

Table 1 lists the Teradata keywords and features that can be migrated.

The Version column contains the earliest versions that support the keywords or features.

The Remarks column contains the configuration parameters to customize how the migration tool migrates the corresponding keywords or features.

**Table 1** Supported Teradata keywords and features
Section	Object->Keyword/Feature		Version	Remarks
Data Type	Data Type		6.5.1, 18.2.0	-
Functions and Operators	Analytical Functions	Analytical Functions in ORDER BY	18.0.0	-
Functions and Operators	Analytical Functions	Analytical Functions in PARTITION BY	18.1.0	-
Functions and Operators	Math Functions	** MOD NULLIFZERO ZEROIFNULL	V100R003C00	Configurable: tdMigrateNULLIFZERO and tdMigrateZEROIFNULL (18.0.0)
Functions and Operators	String Functions	CHAR Function CHARACTERS INDEX STRREPLACE OREPLACE	V100R003C00	-
Functions and Operators	Date and Time Functions	DATE TIMESTAMP NEXT	V100R003C00 18.0.0 V100R003C00	-
Functions and Operators	Comparison and List Operators	^= and GT EQ and NE LE and GE NOT= and LT IN and NOT IN IS NOT IN LIKE ALL/NOT LIKE ALL LIKE ANY/NOT LIKE ANY	V100R003C00	-
Functions and Operators	Table Operators	-	18.0.0	-
Functions and Operators	Query Migration Operators	QUALIFY	V100R003C00	Configurable: rowstoreToColumnstore
		ALIAS	V100R003C00	Configurable: tdMigrateALIAS
		FORMAT and CAST	V100R003C00	-
		Short Keys Migration	V100R003C00	-
		Object Names Starting with $	18.0.0	Configurable: tdMigrateDollar
Functions and Operators	Query Optimization Operators	IN and NOT IN Conversion	V100R003C00	Configurable: inToExists
Schema Objects and Data Definition Language (DDL)	Migrating Tables	CREATE TABLE	V100R003C00	Configurable: session_mode
		CHARACTER SET and CASESPECIFIC	18.1.0	Configurable: tdMigrateCharsetCase
		VOLATILE	V100R003C00	Configurable: volatile and session_mode
		SET	V100R003C00	-
		MULTISET	V100R003C00	-
		TITLE	V100R003C00	-
		Indexes	V100R003C00	-
		CONSTRAINT	V100R003C00	-
		COLUMN STORE	V100R003C00	Configurable: rowstoreToColumnstore
		PARTITION	18.0.0	-
		ANALYZE	V100R003C30	-
		Support for Specified Columns	18.0.0	-
Schema Objects and Data Definition Language (DDL)	Migrating Indexes		V100R003C00	-
Schema Objects and Data Definition Language (DDL)	Migrating Views	REPLACE VIEW	V100R003C00	-
		CHECK OPTION	V100R003C00	-
		VIEW WITH RECURSIVE	V100R003C00	-
		VIEW WITH ACCESS LOCK	V100R003C00	-
Schema Objects and Data Definition Language (DDL)	COLLECT STATISTICS		V100R003C00	-
Schema Objects and Data Definition Language (DDL)	ACCESS LOCK		V100R003C00	Configurable: tdMigrateLOCKOption
Schema Objects and Data Definition Language (DDL)	DBC.COLUMNS		18.0.0	Custom DB scripts
Schema Objects and Data Definition Language (DDL)	DBC.TABLES		18.1.0	-
Schema Objects and Data Definition Language (DDL)	DBC.INDICES		18.1.0	-
Data Manipulation Language (DML)	SELECT	Order of Clauses	V100R003C00 18.0.0	-
		Extended Group By Clause	V100R003C00	-
		TOP and SAMPLE	V100R003C00	-
Data Manipulation Language (DML)	UPDATE		V100R003C00	-
Data Manipulation Language (DML)	DELETE		V100R003C00	-
Data Manipulation Language (DML)	MERGE		V100R003C00	-
Data Manipulation Language (DML)	NAMED		18.0.0	-
Type Casting and Formatting	CHAR COLUMNS and COLUMN ALIAS Expression INT DATE DAY to SECOND DECIMAL Time Interval NULL Implicit Type Casting Issues		V100R003C00	-