DB2 Datatype | Supported for Bulk Data Movement? |
|---|---|
BIGINT | Yes |
BINARY | Yes |
BLOB | Yes |
CHAR | Yes |
CLOB | Yes |
DATE | Yes |
DBCLOB | Yes |
DECFLOAT | No |
DECIMAL | Yes |
DISTINCT (user-defined) | No |
DOUBLE | Yes |
FLOAT | Yes |
GRAPHIC | Yes |
LONG VARCHAR | Yes |
LONG VARGHAPHIC | Yes |
INTEGER | Yes |
REAL | Yes |
ROWID | No |
SMALLINT | Yes |
TIME | Yes |
TIMESTAMP | Yes, including extended-precision TIMESTAMP columns, which support fractional seconds up to 12 digits |
TIMESTAMP WITH TIME ZONE | No |
VARBINARY | Yes |
VARCHAR | Yes |
VARGRAPHIC | Yes |
XML | No |