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.