DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.CASTFUNCTIONS catalog view

Each row represents a cast function, not including built-in cast functions.

Table 1. SYSCAT.CASTFUNCTIONS Catalog View
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)  
  • N = Not an assignment function
  • Y = Implicit assignment function