Skip to main content

IBM Db2 Data 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 TypeDremio Type
BIGINTBIGINT
BLOBVARCHAR
BOOLEANBOOLEAN
CHARVARCHAR
CHAR () FOR BIT DATAVARCHAR
CLOBVARCHAR
DATEDATE
DBCLOBVARCHAR
DECFLOATDECIMAL
DECIMALDECIMAL
DOUBLEDOUBLE
GRAPHICVARCHAR
INTEGERINTEGER
LONG VARCHARVARCHAR
LONG VARCHAR FOR BIT DATAVARCHAR
LONG VARGRAPHICVARCHAR
REALDOUBLE
SMALLINTINTEGER
TIMETIME
TIMESTAMPTIMESTAMP
VARCHARVARCHAR
VARCHAR () FOR BIT DATAVARCHAR
VARGRAPHICVARCHAR