Skip to main content

IBM DB2 for iSeries database source data types

The following table shows the IBM DB2 for iSeries 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 iSeries 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

CHAR (n)

If n<=32 KB, then:

STRING

VARCHAR (n)

If n<=32 KB, then:

STRING

GRAPHIC (n)

If n<=16 KB, then:

STRING

VARGRAPHIC (n)

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

STRING

DATE

DATE

TIME

TIME

TIMESTAMP

DATETIME (6)

BLOB

BLOB

Maximum size: 2 GB

CLOB

CLOB

Maximum size: 2 GB

DBCLOB

CLOB

Maximum size: 1 GB double byte chars

ROWID

BYTES - This should be a user-defined column.

DATALINK

STRING

TIMESTAMP WITH TIME ZONE

NOT SUPPORTED