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 Types		6.5.1, 18.2.0	-
  Functions and Operators	Analytical Functions	Analytical Functions in ORDER BY	18.0.0	-
  		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 Function 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	-
  		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		V100R003C00	-