On this page

    IBM DB2 Data Types

    note:

    Not Supported: Enterprise Edition only
    The DB2 connector is deprecated as of Dremio 3.1.3. Existing DB2 source connections will continue to function in this release, but any new DB2 connections will not be possible.

    DB2 was officially removed from the product in Dremio 4.0, causing existing DB2 connections to fail. Dremio may choose to develop a newer DB2 connector in the future.

    Remove this page?

    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.

    Is DOUBLE to DECIMAL correct? Shouldn't it be DECIMAL TO DECIMAL?

    DB2 Database TypeDremio Type
    BIGINTBIGINT
    BLOBVARBINARY
    BOOLEANBOOLEAN
    CHARVARCHAR
    CHAR () FOR BIT DATAVARCHAR
    CLOBVARCHAR
    DATEDATE
    DBCLOBVARCHAR
    DECFLOATDOUBLE
    DECIMALDOUBLE
    DOUBLEDOUBLE
    GRAPHICVARCHAR
    INTEGERINTEGER
    LONG VARCHARVARCHAR
    LONG VARCHAR FOR BIT DATAVARBINARY
    LONG VARGRAPHICVARCHAR
    REALFLOAT
    SMALLINTINTEGER
    TIMETIME
    TIMESTAMPTIMESTAMP
    VARCHARVARCHAR
    VARCHAR () FOR BIT DATAVARBINARY
    VARGRAPHICVARCHAR