Data types

Valid data types are:

INTEGER
SMALLINT
BIGINT
DECIMAL
DECFLOAT
NUMERIC
FLOAT
CHARACTER
VARCHAR
GRAPHIC
VARGRAPHIC
DATE
TIME
TIMESTAMP
DATALINK
CLOB
BLOB
DBCLOB
BINARY
VARBINARY
ROWID

Any user-defined types (UDTs) that you have defined on your system will also appear as a valid data type.

Note: For data types where the size is predetermined, the size is filled in and you cannot change the value.

For more detailed information on data types, see Data types in the SQL Reference topic in the Information Center Link to Information center.