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.
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) |