This box contains the data type currently specified for
the column. You cannot alter this box for an existing column. To
specify a different data type for a column that you're adding, click on
the down arrow to display a list of data types and select one.
The data type can be one of:
- INTEGER
- For a large integer with a precision of 11 digits.
- SMALLINT
- For a small integer with a precision of 5 digits.
- BIGINT
- For a large integer with a precision of 19 digits.
- DOUBLE
- For a floating-point number. Double Precision and Float are
synonyms for Double.
- DECIMAL
- For a decimal number.
- CHARACTER
- For a fixed-length character string.
- VARCHAR
- For a varying-length character string with a maximum length of
4000.
- LONG VARCHAR
- For a varying-length character string with a maximum length of
32700.
- BLOB
- For a binary large object string.
- CLOB
- For a character large object string.
- DBCLOB
- For a double-byte character large object string.
- GRAPHIC
- For a fixed-length graphic string.
- VARGRAPHIC
- For a varying-length graphic string with a maximum length of 2000.
- LONG VARGRAPHIC
- For a varying-length graphic string with a maximum length of 16350.
- DATE
- For a date.
- TIME
- For a time.
- TIMESTAMP
- For a timestamp.
- Distinct type
- For a distinct type. Distinct types are listed in the form of
schema.type.
- REAL
- For a single-precision floating-point number.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]