CREATE/REPLACE CAST Examples | Teradata Vantage - CREATE CAST and REPLACE CAST Examples - Teradata Vantage - Analytics Database

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