TYPE_SCHEMA scalar function

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

Read syntax diagramSkip visual syntax diagramTYPE_SCHEMA(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.