Db2 for i Connector > Data type reference > Db2 for i supported data types
  

Db2 for i supported data types

The following table lists the Db2 for i data types that Data Integration supports for bulk data movement:
DB2 Datatype
Supported for Bulk Data Movement?
BIGINT
Yes
BINARY
Yes
BLOB
Yes (sources only)
CHAR
Yes
CLOB
Yes (sources only)
DATALINK
No
DATE
Yes
DBCLOB
Yes (sources only)
DECFLOAT
No
DECIMAL
Yes
DISTINCT (user-defined)
No
DOUBLE
Yes
FLOAT
Yes
GRAPHIC
Yes
INTEGER
Yes
LONG VARCHAR
Yes
LONG VARGHAPHIC
Yes
NUMERIC
Yes
REAL
Yes
ROWID
No
SMALLINT
Yes
TIME
Yes
TIMESTAMP
Yes
VARBINARY
Yes
VARCHAR
Yes
VARGRAPHIC
Yes