Summary

In this chapter, we have talked about very powerful DB2 and SQL features, such as stored procedure and triggers. These features that DB2 provides can help reduce the amount of application development time and maintenance. It can help to encapsulate our code into one place for use by many applications.

DB2 has implemented some object-relational functions, such as large object (LOB) support, user-defined distinct types, user-defined functions, and so on. We have discussed user-defined data types and user-defined functions. These features also allow us great flexibility and power in our applications. LOBs, of course, give us the ability to stored large amounts of data and different types of data such as multi-media, giving us the ability ...

Get DB2® Universal Database for OS/390® Version 7.1 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.