Supported Data Types

The Netezza Adapter supports the following data types for Run a SQL Statement and Perform an Operation On Table operations.

Data Type
BigInt
Boolean
ByteInt
Char
Date
Decimal
Double
Float
Integer
Interval Day
Interval Day To Hour
Interval Day To Minute
Interval Day To Second
Interval Hour
Interval Hour To Minute
Interval Hour_To Second
Interval Minute
Interval Minute To Second
Interval Month
Interval Second
Interval Year
Interval Year To Month
national character varying
Nchar
Numeric
Real
Smallnt
Time
time with time zone
TimeStamp
VarBinary
Varchar