Netezza Performance Server (NPS) target data types
The Netezza Performance Server (NPS) database for Qlik Replicate supports most Netezza Performance Server (NPS) data types. The following table shows the Netezza Performance Server (NPS) target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
Netezza Performance Server (NPS) does not support applying changes to binary data types in Batch optimized apply mode. For more information on Batch optimized apply mode, see Change Processing Tuning.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
| Qlik Replicate Data Types | Netezza Performance Server (NPS) Data Types |
|---|---|
|
BOOLEAN |
BOOLEAN |
|
BYTES |
VARCHAR (Length in Bytes) |
|
DATE |
DATE |
|
TIME |
TIME |
|
DATETIME |
If scale < 7: TIMESTAMP If scale 7-9: CHARACTER VARYING(37) |
|
INT1 |
BYTEINT |
|
INT2 |
SMALLINT |
|
INT4 |
INTEGER |
|
INT8 |
BIGINT |
|
NUMERIC |
NUMERIC (p,s) |
|
REAL4 |
REAL |
|
REAL8 |
DOUBLE |
|
STRING |
VARCHAR (Length) |
|
UINT1 |
SMALLINT |
|
UINT2 |
INTEGER |
|
UINT4 |
BIGINT |
|
UINT8 |
BIGINT |
|
WSTRING |
NVARCHAR (Length) |
|
BLOB |
VARCHAR (64,000) |
|
NCLOB |
NVARCHAR (7,000) |
|
CLOB |
VARCHAR (64,000) |