SYSCAT.CASTFUNCTIONS catalog view
Each row represents a cast function, not including built-in cast functions.
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| FROM_TYPESCHEMA | VARCHAR (128) | Schema name of the data type of the parameter. | |
| FROM_TYPEMODULENAME | VARCHAR (128) | Unqualified name of the module to which the data type of the parameter belongs. The null value if not a module data type. | |
| FROM_TYPENAME | VARCHAR (128) | Name of the data type of the parameter. | |
| FROM_TYPEMODULEID | INTEGER | Y | Identifier for the module to which the data type of the parameter belongs. The null value if not a module data type. |
| TO_TYPESCHEMA | VARCHAR (128) | Schema name of the data type of the result after casting. | |
| TO_TYPEMODULENAME | VARCHAR (128) | Unqualified name of the module to which the data type of the result after casting belongs. The null value if not a module data type. | |
| TO_TYPENAME | VARCHAR (128) | Name of the data type of the result after casting. | |
| TO_TYPEMODULEID | INTEGER | Y | Identifier for the module to which the data type of the result after casting belongs. The null value if not a module data type. |
| FUNCSCHEMA | VARCHAR (128) | Schema name of the function. | |
| FUNCMODULENAME | VARCHAR (128) | Unqualified name of the module to which the function belongs. The null value if not a module function. | |
| FUNCNAME | VARCHAR (128) | Unqualified name of the function. | |
| SPECIFICNAME | VARCHAR (128) | Name of the routine instance (might be system-generated). | |
| FUNCMODULEID | INTEGER | Y | Identifier for the module to which the function belongs. The null value if not a module function. |
| ASSIGN_FUNCTION | CHAR (1) |
|