Users can define their own data types and the functions that operate on these data types. DataBlade modules also provide extended data types and functions to the database server. You can define indexes on the following kinds of user-defined data types:
An opaque data type is a fundamental data type that you can use to define columns in the same way you use built-in types. An opaque data type stores a single value and cannot be divided into components by the database server. For information about creating opaque data types, see the CREATE OPAQUE TYPE statement in the IBM Informix: Guide to SQL Syntax and IBM Informix: User-Defined Routines and Data Types Developer's Guide. For more information on the data types and functions that each DataBlade module provides, see the user guide of each DataBlade module.
A distinct data type has the same representation as an existing opaque or built-in data type but is different from these types. For information about distinct data types, see the IBM Informix: Guide to SQL Reference and the CREATE DISTINCT TYPE statement in the IBM Informix: Guide to SQL Syntax.
For more information on data types, see the IBM Informix: Guide to SQL Reference.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]