Retrieving and modifying structured type values in columns

There are two ways that applications and user-defined functions can access data in structured type columns: by accessing individual attributes of an object, or by assessing the object as a single value.

About this task

If you want to treat an object as a single value, you must first define transform functions. Once you define the correct transform functions, you can select a structured object much as you can any other value:

   SELECT Name, Dept, Address
      FROM Employee
      WHERE Salary > 20000;

The following topics describe how you can explicitly access individual attributes of an object by invoking the Db2® built-in observer and mutator methods. These built-in methods do not require you to define a transform function.