On this page

    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 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