IBM DB2 Data Types
Note:
Not Supported**
**Enterprise Edition only**Deprecated as of Dremio 3.1.3
Deprecated as of Dremio 4.0
DB2 as a connector has been deprecated in this release. Existing DB2 source connections will still continue to function in this release, but any new DB2 connections will not be possible. In the next maintenance release Dremio will be officially removing DB2 from the product causing any existing DB2 connections to fail. Dremio may choose to develop a newer DB2 connector in the future.
Dremio supports selecting the following DB2 Database types. The following table shows the mappings from DB2 to Dremio data types.
Note:
If a type is not present in the table, it is not currently supported.
| DB2 Database Type | Dremio Type |
|---|---|
| BIGINT | bigint |
| BLOB | varbinary |
| BOOLEAN | boolean |
| CHAR | varchar |
| CHAR () FOR BIT DATA | varchar |
| CLOB | varchar |
| DATE | date |
| DBCLOB | varchar |
| DECFLOAT | double |
| DECIMAL | double |
| DOUBLE | double |
| GRAPHIC | varchar |
| INTEGER | integer |
| LONG VARCHAR | varchar |
| LONG VARCHAR FOR BIT DATA | varbinary |
| LONG VARGRAPHIC | varchar |
| REAL | float |
| SMALLINT | integer |
| TIME | time |
| TIMESTAMP | timestamp |
| VARCHAR | varchar |
| VARCHAR () FOR BIT DATA | varbinary |
| VARGRAPHIC | varchar |
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.