- The source data type of the assignment is compatible with the source data type of the cast result.
- The target data types are identical.
- parameter passing
You can disable this functionality by means of the DisableImplCastForSysFuncOp DBS Control parameter.
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