Chapter 15. Object-Relational Functionality

• Triggers

• 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.

Triggers

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:

INSERT

UPDATE

DELETE

A trigger is defined for a specific table. Once defined, a trigger is automatically active. A table can have ...

Get DB2® for z/OS® Version 8 DBA Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.