Supported data types

The following table shows the supported IBM DB2 for iSeries source data types and their default mapping to Qlik Talend Data Integration data types.

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

Supported data types
IBM DB2 for iSeries data types	Qlik Talend Data Integration 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
ROWID	BYTES - This should be a user-defined column.
DATALINK	STRING
TIMESTAMP WITH TIME ZONE	NOT SUPPORTED
BOOLEAN Information note The BOOLEAN data type is supported from iSeries 7.5.	BOOLEAN
BINARY-DECIMAL	NUMERIC If BINARY-DECIMAL has a scale of 0: INTEGER
ZONED-DECIMAL	NUMERIC

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!