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.

Table 1. SYSCAT.TRANSFORMS Catalog View
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)  
  • 'FROM SQL' = Transform function transforms a structured type from SQL
  • 'TO SQL' = Transform function transforms a structured type to SQL
FORMAT CHAR (1)   Format produced by the FROM SQL transform.
  • S = Structured data type
  • U = User-defined
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.
  • O = Original transform group
  • R = Redefined transform group
REMARKS VARCHAR (254) Y User-provided comments, or the null value.