Use this box to specify the data type of the distinct
type that you're creating. 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.
- Real
- For a single-precision floating-point number.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]