O'Reilly logo

DB2® for z/OS® Version 8 DBA Certification Guide by Susan Lawson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required