The TYPE_SCHEMA function returns the schema name of the dynamic data type of the expression.

The schema is SYSIBM.

expression

An expression that returns a value of a user-defined structured data type.

The data type of the result of the function is VARCHAR(128 OCTETS).
If expression can be null, the result can be null; if expression is null, the result is the null value.
Use the TYPE_NAME function to determine the type name associated with the schema name returned by TYPE_SCHEMA.

Notes

• This function cannot be used as a source function when creating a user-defined function.
  Because it accepts any structured data type as an argument, it is not necessary to create additional signatures to support different user-defined types.

Related reference

• TYPE_NAME scalar function