Explore the different datatype to catalog datatype mappings available for DB2 iSeries datasource.
Default mapping
The mapping from IBM DB2 i Series datatype to catalog datatype makes data management simpler and more organized when advanced connector bundle is used.
| Datatype | Catalog datatype |
|---|---|
| BIGINT | integer |
| BLOB | blob |
| CHAR | string |
| CHAR VARYING | string |
| CHAR() FOR BIT DATA | string |
| CHARACTER | string |
| CHARACTER VARYING | string |
| CLOB | string |
| DATALINK | string |
| DATE | date |
| DBCLOB | string |
| DEC | decimal |
| DECIMAL | decimal |
| DOUBLE | double |
| DOUBLE PRECISION | double |
| FLOAT | double |
| GRAPHIC | string |
| GRAPHIC VARYING | string |
| INT | integer |
| INTEGER | integer |
| INTERVAL | string |
| LONG VARCHAR | string |
| LONG VARGRAPHIC | string |
| NUMERIC | decimal |
| REAL | decimal |
| ROWID | integer |
| SMALLINT | integer |
| TIME | time |
| TIMESTAMP | datetime |
| TIMESTMP | datetime |
| VARCHAR | string |
| VARCHAR() FOR BIT DATA | string |
| VARGRAPHIC | string |