Supported target data types

The following table shows the IBM DB2 for z/OS target 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 from the source, see the section for the source endpoint you are using.

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

Supported data types
Qlik Replicate Data Types	IBM DB2 z/OS Data Types
STRING	If length ≤ 32704: VARBINARY (Length) If length > 32704: BLOB (Length)
WSTRING	If length ≤ 16352: VARGRAPHIC (Length) If length > 16352: DBCLOB (Length)
UINT1	SMALLINT
UINT2	INTEGER
UINT4	BIGINT
UINT8	BIGINT
INT1	SMALLINT
INT2	SMALLINT
INT4	INTEGER
INT8	BIGINT
TIMESTAMP	If scale < 7: TIMESTAMP If scale 7-12: VARCHAR (37)
TIME	TIME
DATE	DATE
REAL4	REAL
REAL8	DOUBLE
NUMERIC	If precision ≤ 31 and scale ≤ 31: DECIMAL (p,s) If precision >31 and scale >31: VARCHAR (45)
BOOLEAN	CHAR (5)
BYTES	If length ≤ 32704: VARBINARY (Length) If length > 32704: BLOB (Length)
CLOB	CLOB (2G)
BLOB	BLOB (2G)
NCLOB	DBCLOB (1G)

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 – let us know how we can improve!

Leave your feedback here