• Object-relational extensions
• Large objects
This chapter covers some of the more powerful features of DB2's SQL. The extended programming features, user-defined functions, and table functions are discussed, along with triggers and distinct types. The object-relational extensions used to support these features are also covered, as are implementing and using large objects (LOBs) and DB2 extenders.
An active trigger is a set of actions that will be executed when a defined event occurs. Such an event can be any of the the following SQL statements:
A trigger is defined for a specific table. Once defined, a trigger is automatically active. A table can have ...