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 HCL Informix Guide to SQL: Reference.