IBM DB2 Data Types

[info] DEPRECATED
Enterprise Edition only

Deprecated as Dremio version 3.1.3
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.

[info] 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

results matching ""

    No results matching ""