SQL Reference

TYPE_SCHEMA

>>-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. ⁵⁰

The data type of the result of the function is VARCHAR(128). 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.

⁵⁰

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.