17.05 - AS ASSIGNMENT - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)
To implicitly invoke the specified cast routine on an assignment operation if both of the following statements are true:
  • The source data type of the assignment is compatible with the source data type of the cast result.
  • The target data types are identical.
Note that an assignment operation is defined to be any of the following operations:
  • parameter passing

You can disable this functionality by means of the DisableImplCastForSysFuncOp DBS Control parameter.

Be very careful if you are performing a REPLACE CAST statement because the system updates the UDTCast dictionary to reflect the value of the AS ASSIGNMENT flag.