DB2 to Netezza data type conversions

IBM DB2 Netezza SQL

IBM DB2 Netezza SQL

 

This is a  extract table I created from the IBM source, a while back ,when investing what format to convert data fields into for IBM Informsphere Datastage.  I have had it floating around in my notes, but lately, I have found myself referencing  it to help other team members, so, it seems useful to include it here.   The notes column is just a few snippits of information, which I have found useful to reference when planning data field conversions.

 

Transformer data type DB2 data type Netezza data type Notes
BIGINT BIGINT BIGINT
BINARY CHARACTER Not supported
BIT SMALLINT BOOLEAN
CHAR CHARACTER CHAR
DATE DATE DATE
DECIMAL DECIMAL NUMERIC or DECIMAL
DOUBLE DOUBLE DOUBLE PRECISION or FLOAT(15)
FLOAT DOUBLE FLOAT
INTEGER INTEGER INTEGER
LONGVARBINARY BLOB Not supported
LONGVARCHAR CLOB VARCHAR The maximum character string size is 64,000.
NUMERIC DECIMAL NUMERIC
REAL REAL REAL or FLOAT(6)
SMALLINT SMALLINT SMALLINT
TIME TIME TIME DB2 9.1 TIME data type does not support fractional digits or microseconds.
TIMESTAMP TIMESTAMP TIMESTAMP DB2 9.1 TIME data type does not support fractional digits or microseconds.
TINYINT SMALLINT BYTEINT
VARBINARY VARCHAR Not supported
VARCHAR VARCHAR VARCHAR The maximum character string size is 64,000.
WCHAR GRAPHIC Not supported
WLONGVARCHAR LONG VARGRAPHIC Not supported
WVARCHAR VARGRAPHIC Not supported

 

Related References

InfoSphere Information Server InfoSphere Information Server 11.5.0 – Data types

IBM PureData System for Analytics, Version 7.1 – Data types and aliases