Skip to main content

IBM DB2 for LUW Database source data types

The following table shows the IBM DB2 for LUW database source data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.

For information on how to view the data type that is mapped in the target, see the section for the target database you are using.

For additional information about Qlik Replicate data types, see Replicate data types.

Supported data types
IBM DB2 for LUW Source Data Types Qlik Replicate Data Types

INTEGER

INT4

SMALLINT

INT2

BIGINT

INT8

DECIMAL (p,s)

NUMERIC (p,s)

FLOAT

REAL8

DOUBLE

REAL8

REAL

REAL4

DECFLOAT (p)

If precision = 16, then:

REAL8

If precision is = 34, then:

STRING

GRAPHIC (n)

If n<=127 KB, then:

WSTRING

VARGRAPHIC (n)

If n<=16k double byte chars, then:

WSTRING

LONG VARGRAPHIC

CLOB

CHAR (n)

STRING

n<=255

VARCHAR (n)

STRING

n<=32k

LONG VARCHAR (n)

CLOB

n<=32k

CHAR (n) FOR BIT DATA

BYTES

VARCHAR (n) FOR BIT DATA

BYTES

LONG VARCHAR FOR BIT DATA

BYTES

DATE

DATE

TIME

TIME

TIMESTAMP

DATETIME

BLOB

BLOB

CLOB

CLOB

Maximum size: 2 GB

DBCLOB

CLOB

Maximum size: 1 G double byte chars

XML

CLOB