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