Chapter 13. Advanced SQL

DB2 Universal Database provides several object-oriented functions through SQL that offer the programmer several options on how business logic or rules are implemented in their program. These features include large object support, user-defined types, triggers, and routines. These features offer you many benefits, including the ability to reuse code, create objects that more closely imitate the way we think of things, keep objects and functions for use by multiple applications closer to data, and create more flexible applications.

Today you learn the following:

  • How to use constraints to implement business rules

  • How to create user-defined types to extend the data types supported by the database

  • How to implement business rules ...

Get Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition 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.