DB2 to Netezza data type conversions

IBM DB2 Netezza SQL
IBM DB2 Netezza SQL

This is an extract table I created from the IBM source, a while back when investing what format to convert data fields into for IBM Infosphere 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 snippets of information, which I have found useful to reference when planning data field conversions.

Transformer data typeDB2 data typeNetezza data typeNotes
BIGINTBIGINTBIGINT 
BINARYCHARACTERNot supported 
BITSMALLINTBOOLEAN 
CHARCHARACTERCHAR 
DATEDATEDATE 
DECIMALDECIMALNUMERIC or DECIMAL 
DOUBLEDOUBLEDOUBLE PRECISION or FLOAT(15) 
FLOATDOUBLEFLOAT 
INTEGERINTEGERINTEGER 
LONGVARBINARYBLOBNot supported 
LONGVARCHARCLOBVARCHARThe maximum character string size is 64,000.
NUMERICDECIMALNUMERIC 
REALREALREAL or FLOAT(6) 
SMALLINTSMALLINTSMALLINT 
TIMETIMETIMEDB2 9.1 TIME data type does not support fractional digits or microseconds.
TIMESTAMPTIMESTAMPTIMESTAMPDB2 9.1 TIME data type does not support fractional digits or microseconds.
TINYINTSMALLINTBYTEINT 
VARBINARYVARCHARNot supported 
VARCHARVARCHARVARCHARThe maximum character string size is 64,000.
WCHARGRAPHICNot supported 
WLONGVARCHARLONG VARGRAPHICNot supported 
WVARCHARVARGRAPHICNot supported 

Related References

InfoSphere Information Server InfoSphere Information Server 11.5.0 – Datatypes

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