DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide

Object-Relational Extensions

With the object extensions of DB2, you can incorporate object-oriented concepts and methodologies into your relational database by extending DB2 with richer sets of data types and functions. With those extensions, you can store instances of object-oriented data types in columns of tables and operate on them using functions in SQL statements. In addition, you can control the types of operations that users can perform on those data types. The object extensions that DB2 provides are

• Large objects (LOBs)

• Distinct types

• UDFs

Schemas

Schemas are qualifiers used for the object-relational extensions as well as stored procedures. They are used to qualify

• User-Defined Distinct Types

• UDFs

• Stored Procedures

• Triggers

All of the objects ...