SQL Reference

OBJCAT.TRANSFORMS

Contains a row for each transform function type within a user-defined type contained in a named transform group.

Table 115. OBJCAT.TRANSFORMS Catalog View

Column Name	Data Type	Nullable	Description
TYPEID	SMALLINT		Internal type ID as defined in SYSCAT.DATATYPES
TYPESCHEMA	VARCHAR(128)		Qualified name of the given user-defined structured type.
TYPENAME	VARCHAR(18)
GROUPNAME	VARCHAR(18)		Transform group name.
FUNCID	INTEGER	Yes	Internal function ID for the associated transform function, as defined in SYSCAT.FUNCTIONS. Null only for internal system functions.
FUNCSCHEMA	VARCHAR(128)		Qualified name of the associated transform functions.
FUNCNAME	VARCHAR(18)
SPECIFICNAME	VARCHAR(18)		Function specific (instance) name.
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)		'U' = User defined
MAXLENGTH	INTEGER	Yes	Maximum length (in bytes) of output from the FROM SQL transform. Null for TO SQL transforms.
ORIGIN	CHAR(1)		'I' = Inherited down type hierarchy. 'U' = User defined.
REMARKS	VARCHAR(254)	Yes	User-supplied comment or null.