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	-
  		Analytical Functions in PARTITION BY	18.1.0	-
  	Math Functions	** MOD NULLIFZERO ZEROIFNULL	V100R003C00	Configurable: tdMigrateNULLIFZERO and tdMigrateZEROIFNULL (18.0.0)
  	String Functions	CHAR Function CHARACTERS INDEX STRREPLACE OREPLACE	V100R003C00	-
  	Date and Time Functions	DATE TIMESTAMP NEXT	V100R003C00 18.0.0 V100R003C00	-
  	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	-
  	Table Operators	-	18.0.0	-
  	Query Optimization Operators	IN and NOT IN Conversion	V100R003C00	Configurable: inToExists
  	QUALIFY	-	V100R003C00	Configurable: rowstoreToColumnstore
  	ALIAS		V100R003C00	Configurable: tdMigrateALIAS
  	FORMAT and CAST		V100R003C00	-
  	Short Keys Migration		V100R003C00	-
  	Migration of Object Names Starting with $		18.0.0	Configurable: tdMigrateDollar
  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	-
  Migrating Indexes	-		V100R003C00	-
  Migrating Views	REPLACE VIEW CHECK OPTION VIEW WITH RECURSIVE VIEW WITH ACCESS LOCK		V100R003C00	-
  COLLECT STATISTICS	-		V100R003C00	-
  ACCESS LOCK	-		V100R003C00	Configurable: tdMigrateLOCKOption
  DBC.COLUMNS	-		18.0.0	Custom DB scripts
  DBC.TABLES	-		18.1.0	-
  DBC.INDICES	-		18.1.0	-
  Data Manipulation Language (DML)	SELECT		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	-