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.
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 ]