IBM Books

Data type

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 ]