• RECURSIVE SQL
• OUTER JOIN
• CASE EXPRESSIONS
• TYPED TABLES
• SUMMARY TABLES
• ADVANCED FUNCTIONS
This chapter will cover some very powerful features found in DB2 SQL. Features, such as triggers, recursion, outer join, OLAP features, and uses of the case expression, will be discussed. In addition, we will discuss structured types, typed tables, user-defined functions, summary tables, sequences and some advanced functions.
A trigger is a set of actions that will be executed when a defined event occurs. The triggering events can be the following SQL statements:
Triggers are defined for a specific table and once defined, a trigger is automatically active. ...