SYSCAT.TRANSFORMS catalog view
Each row represents the functions that handle transformations between a user-defined type and a base SQL type, or the reverse.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TYPEID | SMALLINT | Identifier for the data type. | |
TYPESCHEMA | VARCHAR (128) | Schema name of the data type if TYPEMODULEID is null; otherwise schema name of the module to which the data type belongs. | |
TYPENAME | VARCHAR (128) | Unqualified name of the data type. | |
GROUPNAME | VARCHAR (128) | Name of the transform group. | |
FUNCID | INTEGER | Identifier for the routine. | |
FUNCSCHEMA | VARCHAR (128) | Schema name of the routine if ROUTINEMODULEID is null; otherwise schema name of the module to which the routine belongs. | |
FUNCNAME | VARCHAR (128) | Unqualified name of the routine. | |
SPECIFICNAME | VARCHAR (128) | Name of the routine instance (might be system-generated). | |
TRANSFORMTYPE | VARCHAR (8) |
|
|
FORMAT | CHAR (1) | Format produced by the FROM SQL transform.
|
|
MAXLENGTH | INTEGER | Y | Maximum length (in bytes) of output from the FROM SQL transform; the null value for TO SQL transforms. |
ORIGIN | CHAR (1) | Source of this group of transforms.
|
|
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |