SQL Reference

TYPE_NAME

>>-TYPE_NAME---(--expression--)--------------------------------><
 

The schema is SYSIBM.

The TYPE_NAME function returns the unqualified 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(18). If expression can be null, the result can be null; if expression is null, the result is the null value. Use the TYPE_SCHEMA function to determine the schema name of the type name returned by TYPE_NAME.

Examples:

• A table hierarchy exists having root table EMPLOYEE of type EMP and subtable MANAGER of type MGR. Another table ACTIVITIES includes a column called WHO_RESPONSIBLE that is defined as REF(EMP) SCOPE EMPLOYEE. For each reference in ACTIVITIES, display the type of the row that corresponds to the reference.

    SELECT TASK, WHO_RESPONSIBLE->NAME,
           TYPE_NAME(DEREF(WHO_RESPONSIBLE)),
           TYPE_SCHEMA(DEREF(WHO_RESPONSIBLE))
      FROM ACTIVITIES
  

  The DEREF function is used to return the object corresponding to the row.

⁴⁹

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.