>>-TYPE_SCHEMA---(--expression--)------------------------------><
The schema is SYSIBM.
The TYPE_SCHEMA function returns the schema name of the dynamic data type of the expression.
The argument must be a user-defined structured type. (40)
The data type of the result of the function is CHAR(8). 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.
Examples:
See Examples section in TYPE_NAME.
(40) This function may not be used as a source function when creating a user-defined function. Since it accepts any structured data type as an argument, it is not necessary to create additional signatures to support different user-defined types.