Supported data types
The following table shows the supported IBM DB2 for iSeries source data types and their default mapping to Data Movement gateway data types.
For information on how to view the data type that is mapped in the target, see the section for the target connector you are using.
| IBM DB2 for iSeries data types | Data Movement gateway data types |
|---|---|
|
INTEGER |
INT4 |
|
SMALLINT |
INT2 |
|
BIGINT |
INT8 |
|
DECIMAL (p,s) |
NUMERIC (p,s) |
|
FLOAT |
REAL8 |
|
DOUBLE |
REAL8 |
|
REAL |
REAL4 |
|
CHAR (n) |
If n<=32 KB, then: STRING |
|
VARCHAR (n) |
If n<=32 KB, then: STRING |
|
GRAPHIC (n) |
If n<=16 KB, then: STRING |
|
VARGRAPHIC (n) |
If n<=16 KB double byte chars, then: STRING |
|
DATE |
DATE |
|
TIME |
TIME |
|
TIMESTAMP |
DATETIME (6) |
|
BLOB |
BLOB Maximum size: 2 GB |
|
CLOB |
CLOB Maximum size: 2 GB |
|
ROWID |
BYTES - This should be a user-defined column. |
|
DATALINK |
STRING |
|
TIMESTAMP WITH TIME ZONE |
NOT SUPPORTED |