Use this box to specify the data type of the column that you're
adding. To specify the data type, 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 varying-length graphic string with a maximum length of 1,073,741,823
double-byte characters.
- GRAPHIC
- For a fixed-length graphic string of double-byte characters.
- VARGRAPHIC
- For a varying-length graphic string with a maximum length of 2,000
double-byte characters.
- LONG VARGRAPHIC
- For a varying-length graphic string with a maximum length of 16,350
double-byte characters.
- 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 ]