CREATE/REPLACE CAST Examples | Teradata Vantage - 17.10 - CREATE CAST and REPLACE CAST Examples - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

Example: Casting Source Data as VARCHAR

The following CREATE CAST request creates a cast operation that converts the source data type circle to the target data type VARCHAR(32) using the method having the specific method name circleToVarchar.

     CREATE CAST (circle AS VARCHAR(32))
     WITH SPECIFIC METHOD SYSUDTLIB.circleToVarchar

Example: Casting Source Data using a UDF

The following CREATE CAST request creates a cast operation that converts the source data type VARCHAR(32) to the target data type circle using the UDF having the specific function name VarcharTocircle.

     CREATE CAST (VARCHAR(32) AS circle)
     WITH SPECIFIC FUNCTION SYSUDTLIB.VarcharTocircle

Example: Casting Source Data as VARCHAR with an Assignment Operation

The following CREATE CAST request creates a cast operation that converts the source data type euro to the target data type VARCHAR(20) using the method euroString.

The casting routine is defined so it is implicitly invoked on an assignment operation assuming the necessary conditions are met for the assignment.

     CREATE CAST (euro AS VARCHAR(20))
     WITH METHOD SYSUDTLIB.euroString( ) FOR euro
     AS ASSIGNMENT