Home | Previous Page | Next Page   Object-Relational Databases > Creating and Using Extended Data Types in Dynamic Server >

Complex Data Types

A complex data type is usually a composite of other existing data types. For example, you might create a complex data type whose components include built-in types, opaque types, distinct types, or other complex types. An important advantage that complex data types have over user-defined types is that users can access and manipulate the individual components of a complex data type.

In contrast, built-in types and user-defined types are self-contained (encapsulated) data types. Consequently, the only way to access the component values of an opaque data type is through functions that you define on the opaque type.

Figure 27 shows the complex data types that Dynamic Server supports and the syntax that you use to create the complex data types.

Figure 27. Complex Data Types
begin figure description - This figure is described in the surrounding text. - end figure description

The complex data types that Figure 27 illustrates provide the following extended data type support:

For more information about how to perform SELECT, INSERT, UPDATE, and DELETE operations on the complex data types that this chapter describes, see the IBM Informix: Guide to SQL Tutorial.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]