Data Type

The Data Type segment specifies the data type of a column, of a component of a collection, of a field within a ROW type, of a routine parameter, or of a value returned by an expression or by a cast function. Use this segment whenever you see a reference to a data type in a syntax diagram.

Syntax


Data Type

                            (1)                 
|--+-| Built-In Data Type |-----------------+-------------------|
   |  (2)                             (3)   |   
   '-----+-| User-Defined Data Type |-----+-'   
         |                       (4)      |     
         '-| Complex Data Type |----------'

Notes:

See Built-In Data Types
Informix® extension
See User-Defined Data Type
See Complex Data Type

Usage

Sections that follow summarize these data types. For more information, see the chapter about data types in the IBM® Informix Guide to SQL: Reference.