October 2004
Intermediate to advanced
688 pages
16h 35m
English
• 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.
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 ...