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. (39)

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.

Footnotes:

(39) 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.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]